--我的理解是你把所有字段的值合并成一个字段,然后再插入B表的B1字段 go if OBJECT_ID('tri_test')is not null drop trigger tri_test go create trigger tri_test on A after insert as declare @str varchar(max) set @str='' select @str=@str+'+ltrim('+name+')' from syscolumns where id=object_id('A') set @str='insert B(B1)select ' +right(@str,len(@str)-1)+ ' from inserted' exec(@str)
--我的理解是你把所有字段的值合并成一个字段,然后再插入B表的B1字段
go
if OBJECT_ID('tri_test')is not null
drop trigger tri_test
go
create trigger tri_test on A
after insert
as
declare @str varchar(max)
set @str=''
select @str=@str+'+ltrim('+name+')'
from syscolumns where id=object_id('A')
set @str='insert B(B1)select '
+right(@str,len(@str)-1)+ ' from inserted'
exec(@str)