在非本数据库获取表的标识列名称
--2000
SELECT name
from pubs..syscolumns
WHERE id = object_id('pubs..test')
and autoval is not null
--2005
SELECT name
from pubs..syscolumns
WHERE id = object_id('pubs..test')
and colstat =1
在非本数据库获取表的标识列名称
--2000
SELECT name
from pubs..syscolumns
WHERE id = object_id('pubs..test')
and autoval is not null
--2005
SELECT name
from pubs..syscolumns
WHERE id = object_id('pubs..test')
and colstat =1