
SQL Server
craigzhang
这个作者很懒,什么都没留下…
展开
专栏收录文章
- 默认排序
- 最新发布
- 最早发布
- 最多阅读
- 最少阅读
-
SQL server 2005 I Ranking Functions and TOP operator
The Database Engine in SQL server 2005 introduces a new category of functions called ranking functions. The functions that make up this category are: RANK: Returns the rank of each row wi原创 2007-06-18 15:05:00 · 587 阅读 · 0 评论 -
The PK of a table
Here is the code to get the PK of a table.CREATE PROCEDURE GetTablePK(@TableName Varchar(20) = NULL)ASBEGINselect [name] from syscolumns where [id] in (select [id] from sysobjects原创 2007-06-18 14:37:00 · 473 阅读 · 1 评论 -
CLR Triggers
A trigger is a special type of stored procedure that automatically runs when a language event executes. SQL Server includes two general types of triggers: data manipulation language (DML) and data def原创 2007-06-18 15:01:00 · 525 阅读 · 0 评论