注册 登录
Office中国论坛/Access中国论坛 返回首页

zhuyiwen的个人空间 http://www.office-cn.net/?625 [收藏] [复制] [分享] [RSS]

日志

TSQL 求表的主键

已有 1929 次阅读2015-6-6 13:48 |个人分类:TSQL| 主键

CREATE FUNCTION dbo.fGetPrimaryKeyList (@TableName sysname) RETURNS Table
AS RETURN
(
SELECT a.[name] as PriKey
  FROM sys.syscolumns AS a RIGHT OUTER JOIN
(SELECT id, colid
  FROM sys.sysindexkeys
          WHERE id =
(SELECT id
  FROM sys.sysindexes
 WHERE [name] =
(SELECT [name]
  FROM sys.objects
 WHERE (type = 'PK') AND (parent_object_id = OBJECT_ID(@TableName))
)
)
) AS b ON a.id = b.id AND a.colid = b.colid
)

评论 (0 个评论)

facelist doodle 涂鸦板

您需要登录后才可以评论 登录 | 注册

QQ|站长邮箱|小黑屋|手机版|Office中国/Access中国 ( 粤ICP备10043721号-1 )  

GMT+8, 2024-3-29 08:52 , Processed in 0.084829 second(s), 17 queries .

Powered by Discuz! X3.3

© 2001-2017 Comsenz Inc.

返回顶部