罗明超常用SQL语句整理

1、在sql server 2000中根据表名得出表中所有字段名：
select B.name from sysobjects as A inner join syscolumns as B on A.name='user' and A.id=B.id order by B.colid