2008年6月15日
My interested stuff(2008-06-18)
摘要： 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 代码乱了 阅读(360) 评论(0) 推荐(0) 编辑
(原创)SQL Server中几种特殊的“字符串到列表”的处理函数
摘要： 普通的字符串分割函数已经见得很多了，写法性能也大不一样，通常都是直接基于字符串的处理，这里就不列出了。下面介绍几种特殊的方式 阅读全文
posted @ 2008-06-15 12:47 代码乱了 阅读(2469) 评论(3) 推荐(0) 编辑
Map SQL Server Profiler EventClass ID to its name in a saved trace table
摘要： 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 代码乱了 阅读(648) 评论(0) 推荐(0) 编辑
(转)QueryADataset
摘要： 在Dataset中使用sql join查询两个表 阅读全文
posted @ 2008-06-15 01:31 代码乱了 阅读(428) 评论(5) 推荐(0) 编辑
(转)SQL Server 2005: Get full information about transaction locks
摘要： 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 代码乱了 阅读(495) 评论(2) 推荐(0) 编辑