查询方法一:
(一般正常顺序输出么有问题,但我遇到了按照首字母排序输出的情况,原因不明)
select name from syscolumns where id = object_id('表名')
例子:
遇到了这种情况,原因不明:
查询方法二:
(始终正常输出)
declare @objid int,@objname char(40)
set @objname = '表名'
select @objid = id
from sysobjects
where id = object_id (@objname)
select 'Column_name' = name
from syscolumns
where id = @objid
order by colid