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