MS SQL Server Triggers

Trigger

Name: TRG_SUB_INSERT

Content:

GO CREATE TRIGGER TRG_SUB_INSERT ON SUBSCRIPTION AFTER INSERT AS BEGIN IF (SELECT CODE FROM INSERTED) is not null BEGIN DECLARE @asCode int; SELECT @asCode = count(*) from SUBSCRIPTION, INSERTED WHERE SUBSCRIPTION.CODE = INSERTED.CODE AND SUBSCRIPTION.CODE IS NOT NULL AND SUBSCRIPTION.CODE != ''; IF @asCode > 1 BEGIN RAISERROR ('The subscription code is already in the subscription table', 16, 1); END; END; END; GO