22,207
社区成员
发帖
与我相关
我的任务
分享
declare @s varchar(8000),@tbname sysname,@colid sysname
declare cur cursor for select name from sysobjects where type='u'
open cur
fetch cur into @tbname
while @@fetch_status=0
begin
--select @colid=name from syscolumns where colid=1 and id=object_id(@tbname)
set @s='
create trigger tri_'+@tbname+'
on '+@tbname+'
for insert
as
begin
insert 远程数据库.dbtest.dbo.'+@tbname+' select * from inserted
end
'
exec (@s)
fetch cur into @tbname
end
close cur
deallocate cur