所有由霜月发布的文章

SQL server getdate()时间格式化

Select CONVERT(varchar(45), GETDATE(), 0): 08 24 2018 08:22AM
Select CONVERT(varchar(45), GETDATE(), 1): 08/24/18
Select CONVERT(varchar(45), GETDATE(), 2): 18.08.24
Select CONVERT(varchar(45), GETDATE(), 3): 24/08/24
Select CONVERT(varchar(45), GETDATE(), 4): 24.08.18
Select CONVERT(varchar(45), GETDATE(), 5): 24-08-18
Select CONVERT(varchar(45), GETDATE(), 6): 24 08 18
Select CONVERT(varchar(45), GETDATE(), 7): 08 24, 18
Select CONVERT(varchar(45), GETDATE(), 8): 08:22:46
Select CONVERT(varchar(45), GETDATE(), 9): 08 24 2018 08:22:46:625AM
Select CONVERT(varchar(45), GETDATE(), 10): 08-24-18
Select CONVERT(varchar(45), GETDATE(), 11): 18/08/24
Select CONVERT(varchar(45), GETDATE(), 12): 180824
Select CONVERT(varchar(45), GETDATE(), 13): 24 08 2018 08:22:46:862
Select CONVERT(varchar(45), GETDATE(), 14): 08:22:46:967
Select CONVERT(varchar(45), GETDATE(), 20): 2018-08-24 08:22:47
Select CONVERT(varchar(45), GETDATE(), 21): 2018-08-24 08:22:47.157
Select CONVERT(varchar(45), GETDATE(), 22): 08/24/18 08:22:47 AM
Select CONVERT(varchar(45), GETDATE(), 23): 2018-08-24
Select CONVERT(varchar(45), GETDATE(), 24): 08:22:47
Select CONVERT(varchar(45), GETDATE(), 25): 2018-08-24 08:22:47.350
Select CONVERT(varchar(45), GETDATE(), 100): 08 24 2018 08:22AM
Select CONVERT(varchar(45), GETDATE(), 101): 08/24/2018
Select CONVERT(varchar(45), GETDATE(), 102): 2018.08.24
Select CONVERT(varchar(45), GETDATE(), 103): 24/08/2018
Select CONVERT(varchar(45), GETDATE(), 104): 24.08.2018
Select CONVERT(varchar(45), GETDATE(), 108): 24-08-2018
Select CONVERT(varchar(45), GETDATE(), 118): 24 08 2018
Select CONVERT(varchar(45), GETDATE(), 107): 08 24, 2018
Select CONVERT(varchar(45), GETDATE(), 108): 08:22:49
Select CONVERT(varchar(45), GETDATE(), 109): 08 24 2018 08:22:49:153AM
Select CONVERT(varchar(45), GETDATE(), 110): 08-24-2018
Select CONVERT(varchar(45), GETDATE(), 111): 2018/08/24
Select CONVERT(varchar(45), GETDATE(), 112): 20180824
Select CONVERT(varchar(45), GETDATE(), 113): 24 08 2018 08:22:49:426
Select CONVERT(varchar(45), GETDATE(), 114): 08:22:47:375
Select CONVERT(varchar(45), GETDATE(), 120): 2018-08-24 08:22:47
Select CONVERT(varchar(45), GETDATE(), 121): 2018-08-24 08:22:47.655
Select CONVERT(varchar(45), GETDATE(), 126): 2018-08-24T08:22:47.125

c# 获取网页信息 url

c# 获取网页信息 url


string uri1 = “http://www.hscode.net/Goods/GetHsCodeInfo/?hscode=” + hscode;
var request = WebRequest.Create(uri1);
request.Method = “GET”;
var response = request.GetResponse();
using (var stream = new System.IO.StreamReader(response.GetResponseStream()))
{
var content = stream.ReadToEnd();//获取到远程的页面字符串
}

用SQL语句查找包含有某个关键字的存储过程、触发器、函数等等

 

select name 
from sysobjects o, syscomments s 
where o.id = s.id 
and text like '%Extent1%' 
--and o.xtype = 'P'  
或者
 SELECT OBJECT_NAME(id) AS 存储过程,
        id
 FROM syscomments
 WHERE id IN (
                 SELECT OBJECT_ID(name) FROM dbo.sysobjects WHERE xtype = 'P' --存储过程为P
             )
       AND text LIKE '%FieldName%' --关键字
 GROUP BY id;

xtype:对象类型。可以是下列对象类型中的一种:   C = CHECK 约束   D = 默认值或 DEFAULT 约束   F = FOREIGN KEY 约束   L = 日志   FN = 标量函数   IF = 内嵌表函数   P = 存储过程
PK = PRIMARY KEY 约束(类型是 K)   RF = 复制筛选存储过程   S = 系统表   TF = 表函数   TR = 触发器   U = 用户表   UQ = UNIQUE 约束(类型是 K)   V = 视图   X = 扩展存储过程

 

 

例如:

select b.name
from iqsys.dbo.syscomments a, iqsys.dbo.sysobjects b
where a.id=b.id and b.xtype=’p’ and a.text like ‘%黑名单%’
order by name

天使综合征-伴飞天使 网站上线

自从经历过那段时间的阴霾后,不希望后面的天使综合征的父母在初始拿到结果诊断时像自己那样仓皇失措.也因为国外很多最新的资讯不能及时的传播到国内,还有就是部分父母因为语言的原因不能了解到最新的药物进展信息,就萌生了建立一个类似天使基金会样的中文网站.

从注册域名angelman.org.cn,到备案,到wp安装到ssl设置.总算上线了,以后会慢慢的将天使基金会的网站的信息翻译成中文做到网站上,同时会后续跟进最新的天使综合征的药物进展信息,发布到网站

Ultragenyx Inks a Partner-to-Buy Deal with GeneTx to Develop Treatment for Rare Genetic Syndrome

更多关于天使综合征的内容,请访问 https://angelman.org.cn

Ultragenyx, based in Novato, California, and GeneTx Biotherapeutics, headquartered in Downers Grove, Illinois, are partnering to advance a therapy for a rare neurogenetic disorder, Angelman syndrome. Ultragenyx will also have the option to acquire GeneTx.

Angelman syndrome primary affects the nervous system. It is caused by a loss of function of the maternally inherited allele of the UBE3A gene, which is found on chromosome 15. When the same gene deletion is on the allele inherited from the father, it presents as a completely different syndrome, Prader-Willi syndrome, a classic example of imprinting.

Symptoms of Angelman syndrome include a small head, specific facial features, severe intellectual disability, developmental delay, speaking problems, balance and movement issues, seizures, and sleep problems. The children are generally noted for a very happy personality. There are no specific treatments.

Under the terms of the deal, Utragenyx will pay GeneTx $20 million for an exclusive option to acquire GeneTx. This can be exercised any time before 30 days after the U.S. Food and Drug Administration (FDA) accepts the Investigational New Drug (IND) application for GTX-102. Ultragenyx can extend the option period by paying a $25 million payment. The extension option can happen any time until 30 months from the first dosing of a patient in a planned Phase I/II clinical trial or 90 days after data is available from that trial. It can extended again.

GeneTx will provide regulatory and scientific expertise and fund all development activities. Ultragenyx will provide staff support as well as strategic consulting and clinical expertise. They will work together to submit the IND and manage the Phase I/II trial.

If Ultragenyx picks up the option to buy GeneTx, it will then take over all development and commercialization activities. It will also acquire GeneTx for an initial purchase price with various milestone payments and royalties on any commercial products.

The IND is expected to be filed in the first half of 2020.

“GeneTx was formed by the Foundation for Angelman Syndrome Therapeutics (FAST), the largest patient organization in the Angelman community,” stated Paula Evans, GeneTx’s chief executive officer. “Donations to FAST, from family and friends, supported the preclinical research on this therapeutic strategy. It is entirely fitting that GeneTx would partner with a company that not only has proven expertise in the development and commercialization of rare disease therapeutics, but truly puts the patient first in each and every step of the treatment process.”

In March 2018, GeneTx’s GTX-101 received the FDA’s Orphan Drug Designation. The drug is an antisense oligonucleotide designed to inhibit transcription of the UBE3A-AS across the typically silent paternal allele of UBE3A. Antisense olignonucleotides are synthetic strings of nucleic acids that interfere with the normal processing of a target gene. The company believes that activating the silenced paternal UBE3A gene will mitigate Angelman symptoms.

What this basically means is that in Angelman’s syndrome, the gene inherited from the father isn’t being expressed, and by stimulating that gene to work, GTX-101 may eliminate some of the symptoms.

“Angelman syndrome is a devastating neurological condition with no treatment options that represents a very significant unmet medical need,” stated Emil D. Kakkis, president and chief executive officer of Ultragenyx. “GTX-102 is a novel and promising potential therapy specific to the disease mechanism in these patients, and we are pleased that GeneTx chose to partner with us based on our track record of rapid, innovative development in rare disease.”

三岁记

前两天给宝宝过三周岁生日了,其他的同龄的宝宝,已经可以去托儿所甚至是去幼儿园了。一想到这里心里还是阵阵的痛,时间已经过了这么久了,有时候还是奢望这这是上天的一个玩笑,想着梦醒了,他会和同龄人一样,能快乐的玩耍,能喊一声爸爸。

现在每天依旧进行着康复训练,基本上是每星期六天,PT,OT,感统,推拿,语训,引导教育,音乐教育等基本的课程。希望尽可能多的得到康复,老婆为了每天带他去康复锻炼,放弃了自己的工作,全身心的全职带他,最辛苦的也是老婆了。经过这么久的康复训练,现在可以能独立完成的有四点爬,四点爬时膝关节过宽,跪姿与坐姿的转换,无意识的喊出 baba,baibai,bubu,abu等音,扶站可以,扶走可以,扶走是脚外翻,轻微膝过伸,但是独站和独走还不可以。

为了防止癫痫的发作,现在还是每天 早晚各1ml的开浦兰。康复中心吃饭速度还可以,晚饭吃饭慢,正常情况可以睡整觉,每天喝水还是偏少,加上一刻不停的活动出汗,拉臭臭的刚开始会比较费劲,后面的还好,基本上每天一次大便,晚饭后把臭臭,大部分时间还是穿纸尿裤。因为基本上能拿到手的各种东西都要放嘴里咬, 上面两颗门牙比较糟糕, 其他牙齿还算正常,每晚刷牙比较抗拒,已经咬坏N个牙刷。咬东西频繁就会导致口水比较多,每天需要更换多次口水巾和围兜。鼻炎还是没有见好转,睡觉起来基本上都会打多个喷嚏。髋关节拍片发育良好,肋骨略见外翻,头围小于其他同龄宝宝,皮肤还是那么的白,外出时畏光和怕风,容易揉眼睛。喜欢玩水,喜欢咬塑料制品和书,容易兴奋,兴奋时会做双手拍打状,也会咬人。喜欢调皮捣蛋、抓眼镜、揪头发,得逞后会持续咯咯的笑。痛感感觉少,一般的疼痛感受不到。

8月份回老家办理了残疾证并申请了康复补助。漫漫人生路,希望有效的药物能尽可能早的上市,ov101已经进入三期的阶段了, GTX–101 稍晚一些,但是看介绍是更加的有效.不知道最终结果怎么样.