SELECT name
FROM syscolumns
WHERE (id =
(SELECT id
FROM sysobjects
WHERE (id = OBJECT_ID('userinfo'))))
ORDER BY colid
userinfo是表名
SELECT name
FROM syscolumns
WHERE (id =
(SELECT id
FROM sysobjects
WHERE (id = OBJECT_ID('userinfo'))))
ORDER BY colid
userinfo是表名
转载于:https://www.cnblogs.com/freedom831215/archive/2011/01/24/1943245.html