通過(guò)傳入的數(shù)據(jù)表的表名參數(shù)，返回?cái)?shù)據(jù)表中所有的列字段的名稱，中間用“,”分隔開(kāi)。其存儲(chǔ)過(guò)程代碼如下。
    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