As more DBAs across the planet begin using SQL 2005 Tools, but still manage SQL 2000 servers with them, I suspect there will be lots of muffled moaning as to where all the good old features have gone. Although Management Studio has some very nice long-awaited features, some of the good old stuff just isn't there.阅读全文>
发表于 @ 2007年11月02日 02:38:00|评论(loading...)|收藏
Here is one query using the INFORMATION_SCHEMA views that returns both sides of all FOREIGN KEY relationships, as well as the name of the foreign key constraint. 阅读全文>
发表于 @ 2007年10月04日 08:49:00|评论(loading...)|收藏
SQL Server allows developers to query SQL Server and receive data in XML format via a special clause: FOR XML. This clause provides 4 different modes for the XML format returned: RAW, AUTO, EXPLICIT and PATH (new feature of SQL Server 2005)阅读全文>
发表于 @ 2007年03月15日 11:23:00|评论(loading...)|收藏
Tested with SQL Query Analyzer, Ado.net and SP阅读全文>
发表于 @ 2006年08月11日 08:03:00|评论(loading...)|收藏
A insteresting knowledge gotten from a bug:)阅读全文>
发表于 @ 2006年03月22日 15:15:00|评论(loading...)|收藏
构建测试表很有用，呵呵，事实上我就是老记不住SQL Server支持While循环，我总是习惯用FOR循环，结果在帮助里查半天总是找不到。阅读全文>
发表于 @ 2005年03月15日 11:27:00|评论(loading...)|收藏