Skip to navigation
Trigger example
30.05.16
create TRIGGER [dbo].[update_web] ON [SL].[dbo].[av0_style] AFTER UPDATE AS BEGIN IF @@ROWCOUNT = 0 RETURN SET nocount on IF UPDATE(av0_web) DECLARE @av0_web int, @av0_enter_date varchar(max),@av0_code varchar(max) SET @av0_web = (SELECT av0_web FROM inserted) SET @av0_code = (SELECT av0_code FROM inserted) SET @av0_enter_date = CONVERT(VARCHAR(8), GETDATE(), 112) IF( @av0_web = '1') BEGIN UPDATE [SL].[dbo].[av0_style] SET av0_enter_date = @av0_enter_date ,av0_web = '1' WHERE av0_code = @av0_code END ELSE BEGIN UPDATE [SL].[dbo].[av0_style] SET av0_web = 0 WHERE av0_code = @av0_code END END
http://aboutsqlserver.com/2014/01/28/writing-triggers-in-the-right-way/
Reply
Anonymous
Information Epoch 1714890424
Save trees.
Home
Notebook
Contact us