獲得MSSQL表中的所有列字段名稱的方法（存儲過程）
原文地址： http://www.haokaoshi.com/html/JSjdj/3j/sjk/fd/37567.Html
Create Proc pAllColumnSql
(@tableName varchar(50))
as
Declare @Name Varchar(2000)
set @Name =’’
select @Name =@Name + ’,’ + Cast([name] as Varchar)
from syscolumns
where id=object_id(@tableName)
set @name = substring(@name,2,len(@name)-1)
select @name
