![](https://img-blog.csdnimg.cn/20201014180756780.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
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 · 550 阅读 · 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 · 439 阅读 · 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 · 493 阅读 · 0 评论