CREATE FUNCTION dbo.fGetPrimaryKeyList (@TableName sysname) RETURNS Table AS RETURN ( SELECT a. as PriKey FROM sys.syscolumns AS a RIGHT OUTER JOIN (SELECT id, colid FROM sys.sysindexkeys WHERE id = (SELECT id ...
SELECT CASE WHEN a.colorder = 1 THEN d .name ELSE '' END AS 表名 , CASE WHEN a.colorder = 1 THEN isnull(f.value, '') ELSE '' END AS 表说明 , a.colorder AS 字段序号 , a.name AS 字段名 , CASE WHEN COLUMNPROPERTY(a.id, a.name, 'IsIdentity') = 1 THEN '√' ELSE '' END AS 标识 ...
转自: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=76258 This function is used to initialize the seed for the RC4 algorithm CREATE FUNCTION dbo.fnInitRc4 ( @Pwd VARCHAR(256) ) RETURNS @Box TABLE (i TINYINT, v TINYINT) AS BEGIN DECLARE @Key TABLE (i ...
SELECT groupid GroupID , filegroup_name (groupid) GroupName , name FileName , CASE status 0x40 WHEN 0x40 THEN 1 ELSE 0 END IsLogFile , size / 8 SizeKB , maxsize / 8 MaxSizeKB , CASE status 0x100000 WHEN 0x100000 THEN growth ELSE 0 END GrowthPers ...