求一简单sql语句

[st_2000]

取得某表的所有字段名

[zheninchangjiang]

select name from syscolumns where id=object_id('namedtable')

[xluzhong]

select name
from syscolumns
where id=object_id('tablename)

[Softlee81307]

select name from syscolumns where id=object_id(表名)

[Qihua_wu]

SELECT * FROM TABLENAME WHERE 1=2，显示所有字段名

[Qihua_wu]

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

[flashasp]

select name
from syscolumns
where id=object_id('dv_bbs1')

[st_2000]

好像不行

[Softlee81307]

select name from syscolumns where id=object_id(表名)
例子給你看，有一個表叫tc的
select name from syscolumns where id=object_id('tc')
--------就這樣子的