22,209
社区成员
发帖
与我相关
我的任务
分享
CREATE TRIGGER test ON dbo.student
AFTER INSERT
AS
Begin
select * into tmp from inserted
declare cur cursor for select name from syscolumns where id = (select id from sysobjects where name ='student')
declare @buffer varchar(1000)
declare @tmp sysname
declare @sql nvarchar(1000)
declare @data nvarchar(1000)
select @buffer = '###'
open cur
fetch next from cur into @tmp
while @@fetch_status=0
begin
select @sql = N'select @a='+@tmp+' from tmp ;
exec sp_executesql @sql , N'@a sysname output',@data output;
print @sql
print @data
select @buffer = @buffer + convert(varchar , @tmp) +'###' +@data +'###'
fetch next from cur into @tmp
end
close cur
deallocate cur
exec SetFileName 'd:\mybuffer.txt';
exec WriteBuffer @buffer
drop table tmp
end;