--查找该表中的所有列名
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
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