Create Trigger [dbo].[trigger_Update] On [dbo].[T_B] For Update As Begin If Update(C_Id) Begin Declare @a_id int; Declare @c_name nvarchar(50); Select @a_id=A_Id From Inserted; print @a_Id; Select @c_name=c_name From T_C Where c_Id=(Select C_Id From Inserted) Update T_A Set C_name=@c_name Where a_id=@a_id End End
要同步更新table_a 中c_name,把c_name更新成什么样呀?
As
Begin
If Update(C_Id)
Begin
Declare @a_id int;
Declare @c_name nvarchar(50);
Select @a_id=A_Id From Inserted;
print @a_Id;
Select @c_name=c_name From T_C Where c_Id=(Select C_Id From Inserted)
Update T_A Set C_name=@c_name Where a_id=@a_id
End
End