craigzhang的专栏

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

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  

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