create trigger triggerforupdate1 ON empp1 --// declaring trigger name
FOR update
AS
declare @E_name varchar(100);
select @E_name =i.Emp_Name from inserted i;
update empp2
set E_name
=(@E_name);
PRINT 'Record is updated.....'
Tips to improve code,debugging tricks and much more...
Coding Authority Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates
0 comments:
Post a Comment