Sunday, 13 May 2012

0 update after trigger sql server


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.....'

0 comments:

Post a Comment

 

Coding Authority Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates