用触发器:create trigger tr_update on info
for update
as
update info2 set userid = i.userid from deleted d,inserted i where info2.userid = d.userid
go
for update
as
update info2 set userid = i.userid from deleted d,inserted i where info2.userid = d.userid
go
deleted d,inserted i 是什么意思?
inserted 为:当前已插入的记录
info2表的字段时 infoid2 和 userid2 infoid2 是主键的话update info2 set userid = i.userid from deleted d,inserted i where info2.userid = d.userid
中
那个userid是userid2?