如何把纵向表转为横向表(只轉字段名)?
select a.name from syscolumns a join sysobjects b on a.id=b.id
where b.name='authors'
order by a.colorder
結果如下:
au_id
au_lname
au_fname
phone
address
city
state
zip
contract
如何用語句,生成如下的結果:
au_id au_lname au_fname phone address city state zip contract