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...

2007-11-02 02:38:00

阅读数 1294

评论数 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 INF...

2007-10-04 08:49:00

阅读数 1339

评论数 1

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...

2007-03-15 11:23:00

阅读数 1262

评论数 0

SQL Server中直接循环写入数据

构建测试表很有用,呵呵,事实上我就是老记不住SQL Server支持While循环,我总是习惯用FOR循环,结果在帮助里查半天总是找不到。  declare @i intset @i=1while @ibegin  insert into table (colume) values(@i)  se...

2005-03-15 11:27:00

阅读数 1021

评论数 0

取消 删除