摘要： 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 阅读全文

摘要： BOM:The navigator object, which provides detailed information about the browserThe location object, which gives detailed information about the page loaded in the browserThe screen object, which gives detailed information about the user ’ s screen resolutionvaJavascript: script type="text/javascript 阅读全文