获得表的所有字段

alter proc Data_GetTableFields
(
  @tableName nvarchar(50),
  @sql nvarchar(500) out
)
AS
     Declare @fileName nvarchar(50)
     set @sql = ''
     exec ('Declare checkImg  cursor for select [Name]  from syscolumns where [id] = object_id('''+@tableName+''') ')
     open  checkImg
     fetch next  from checkImg   into @fileName
     while @@FETCH_STATUS=0 --FETCH 语句成功
          begin
             if (@fileName <> 'act' and @fileName<>'bakID' and @fileName<>'actID')
               begin
                       if(@filename <>'stamptime')         set @sql=@sql+' ['+@fileName+'] '+','
                end
            fetch next  from checkImg   into @fileName
          end
    close checkImg 
    deallocate checkImg
    set @sql=substring(@sql,0,len(@sql))

declare @sql nvarchar(500)
exec Data_GetTableFields ' 表名 ',@sql out
print @sql