create trigger test1 on User for update as begin declare @name varchar(20) @num int select @num=num,@name=name from inserted update Record set name=@name where num=@num end
解决了,代码如下create trigger tg_Update_Record on T_User for update as begin declare @nickname varchar(20), @ucount varchar(20) select @ucount=UCount,@nickname=UNickName from inserted update T_FriendRecord set FUser1NickName=@nickname where FUser1Count=@ucount update T_FriendRecord set FUser2NickName=@nickname where FUser2Count=@ucount end
on User
for update
as
begin
declare @name varchar(20)
@num int
select @num=num,@name=name from inserted
update Record set name=@name where num=@num
end
on T_User
for update
as
begin
declare @nickname varchar(20),
@ucount varchar(20)
select @ucount=UCount,@nickname=UNickName from inserted
update T_FriendRecord set FUser1NickName=@nickname where FUser1Count=@ucount
update T_FriendRecord set FUser2NickName=@nickname where FUser2Count=@ucount
end