590
社区成员
发帖
与我相关
我的任务
分享
create table tb1
(id int,
UPDATE_FILE text)
create table tb2
(id int,
UPDATE_FILE text)
go
create trigger t1
on tb1
for insert
as
begin
insert into tb2(id)
select id from inserted
update tb2
set UPDATE_FILE=tb1.UPDATE_FILE
from tb1
where tb1.id=tb2.id
end
insert into tb1
values(1,'dafhiahfauidgadig')
select * from tb1
select * from tb2
参照这个吧