常用sql语句

1.获得列名
   use database
   go
    select * from syscolumns where id=(select id from sysobjects where name='tablename') order by name