Skip to navigation
Example of mssql trigger to update a group when one member of the group is changed
13.01.17
create TRIGGER [dbo].[update_web] ON [SL].[dbo].[av0_style] AFTER UPDATE AS IF UPDATE(av0_web) DECLARE @av0_web int, @av0_enter_date varchar(max),@av0_code varchar(max) SET @av0_web = (SELECT TOP 1 av0_web FROM inserted) SET @av0_code = (SELECT TOP 1 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
https://msdn.microsoft.com/en-us/library/ms189799.aspx
Reply
Anonymous
Information Epoch 1757974640
Avoid captive user interfaces.
Home
Notebook
Contact us
