摘要:Sql Server SQL Server 2005: How to have a Unique Constraint with multiple NULLS on a column Biggest difference between Temp tables and Table variables in Sql Server SQL Server: JOIN vs IN... 阅读全文
posted @ 2008-06-15 14:12 代码乱了 阅读 (297) 评论 (0) 编辑
摘要:普通的字符串分割函数已经见得很多了,写法性能也大不一样,通常都是直接基于字符串的处理,这里就不列出了。下面介绍几种特殊的方式 阅读全文
posted @ 2008-06-15 12:47 代码乱了 阅读 (2085) 评论 (3) 编辑
摘要:Map SQL Server Profiler EventClass ID to its name in a saved trace table If you've ever worked with SQL Server profiler then you're familiar with the EventClass column in the trace. It tells you what... 阅读全文
posted @ 2008-06-15 11:46 代码乱了 阅读 (462) 评论 (0) 编辑
摘要:在Dataset中使用sql join查询两个表 阅读全文
posted @ 2008-06-15 01:31 代码乱了 阅读 (260) 评论 (5) 编辑
摘要:SQL Server 2005: Get full information about transaction locks Sometimes we wish to know what locks are being held by the transaction. Also it would be great to know what SPID owns the transaction, on... 阅读全文
posted @ 2008-06-15 00:06 代码乱了 阅读 (379) 评论 (2) 编辑