摘要： 1)Datetime FormatData TypeLanguage-Neutral FormatsExamplesDATETIME'YYYYMMDD hh:mm:ss.nnn''YYYY-MM-DDThh:mm:ss.nnn' 'YYYYMMDD''20090212 12:30:15.123''2009-02-12T12:30:15.123' '20090212'SMALLDATETIME'YYYYMMDD hh:mm''YYYY-MM-DDThh:mm' 'YYYYMMDD''20090212 12:30''2009-02-12T12:30' '20090212'DATE'YYYYMMDD 阅读全文

摘要： 1)字母大小写敏感的写法select *from sys.fn_helpcollations()where name like 'Latin1_General_CS_AS'//大小写敏感select *from [User]where LastName COLLATE Latin1_General_CS_AS like 'Admin'2)SQL 中[]和“” 的一些功能select 'dd' as "first name"select 'dd' as [first name]3)+注意　　select 'dd'+null == nullSET CONCAT_NULL_YIELDS_NULL 阅读全文

摘要： Date:var DateHelper = { ISO2WCF: function(value) { /*var ticks = date.ticks; var GMT = date.dateFormat('TZD'); return ('/Date(' + ticks + GMT + ')/');*/ var reISO = /^(\d{4})-(\d{2})-(\d{2})T(\d{2}):(\d{2}):(\d{2}(?:\.\d*)?)Z$/; var a = reISO.exec(value); if (a) { var val = '/Date(' + new Date(D 阅读全文