select name from syscolumns where id=object_id('tablename)
select name from syscolumns where id=object_id(表名)
SELECT * FROM TABLENAME WHERE 1=2,显示所有字段名
select a.NAME,c.name,a.LENGTH from syscolumns a,sysobjects b,systypes c where a.id = b.id and b.name='UT_SALARYITEM' and b.xtype = 'U' and a.xtype = c.xtype
select name from syscolumns where id=object_id('dv_bbs1')
select name from syscolumns where id=object_id(表名) 例子給你看,有一個表叫tc的 select name from syscolumns where id=object_id('tc') --------就這樣子的
from syscolumns
where id=object_id('tablename)
select a.NAME,c.name,a.LENGTH
from syscolumns a,sysobjects b,systypes c
where a.id = b.id and b.name='UT_SALARYITEM' and b.xtype = 'U' and a.xtype = c.xtype
from syscolumns
where id=object_id('dv_bbs1')
例子給你看,有一個表叫tc的
select name from syscolumns where id=object_id('tc')
--------就這樣子的