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