*tech - SQL Server
文章平均质量分 71
carolbaby
You could read my blog for details
展开
-
SQL Server中直接循环写入数据
构建测试表很有用,呵呵,事实上我就是老记不住SQL Server支持While循环,我总是习惯用FOR循环,结果在帮助里查半天总是找不到。 declare @i intset @i=1while @ibegin insert into table (colume) values(@i) set @i=@i+1end---------------------------------------原创 2005-03-15 11:27:00 · 1218 阅读 · 0 评论 -
Details of "FOR XML" sql clause in SQL-Server
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 a原创 2007-03-15 11:23:00 · 1374 阅读 · 0 评论 -
How do I find all the foreign keys in a database? 如何找到一个数据库中的全部外键(FK)?
原文: http://sqlserver2000.databases.aspfaq.com/schema-how-do-i-find-all-the-foreign-keys-in-a-database.htmlSQL Server Here is one query using the INFORMATION_SCHEMA views that returns both sides of转载 2007-10-04 08:49:00 · 1463 阅读 · 1 评论 -
SQL 2000 to SQL 2005: Where Have All the Old Features Gone?
from SQL-Server-Performance.com By : Boris Baliner As more DBAs across the planet begin using SQL 2005 Tools, but still manage SQL 20转载 2007-11-02 02:38:00 · 1423 阅读 · 0 评论