获得M QL表中的主键的方法（存储过程）

文章作者 100test 发表时间 2007:10:19 11:49:49
来源 100Test.Com百考试题网

创建一个存储过程，通过传入的表名参数，返回该表的主键。其存储过程代码如下：

CREATE Proc pGetPkColumn
(@tableName varchar(50))
as
/*
Create By Peopleyl
获得所要导入数据表的自动递增列
*/
declare @columnName varchar(500)
set @columnName = ’’
SELECT @columnName = @columnName ’,’ c.Name
FROM
sysindexes i,
sysindexkeys k,
sysobjects o,
syscolumns c,
systypes d
WHERE
i.Name like ’pk_%’
AND o.id=i.id
AND o.xType=’U’
AND i.id = k.id
AND i.indid = k.indid
AND i.id = o.id
AND i.id = c.id
AND k.colid = c.colid
and i.indid > 0
and i.indid < 255
and (i.status &. 64)=0
and c.xtype = d.xtype
and o.name = @tableName
if charindex(’,’,@columnName) = 1
0select Stuff(@columnName,1,1,’’)
else
0select @columnName