set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER TRIGGER [dbo].[T_tblSmetki_Stavki_ITrig] ON [dbo].[tblSmetki_Stavki] FOR INSERT AS SET NOCOUNT ON /* * PREVENT INSERTS IF NO MATCHING KEY IN 'tblArtikli' */ IF (SELECT COUNT(*) FROM inserted) != (SELECT COUNT(*) FROM tblArtikli, inserted WHERE (tblArtikli.ID_Artikal = inserted.ssStavka)) BEGIN RAISERROR 44447 'The record can''t be added or changed. Referential integrity rules require a related record in table ''tblArtikli''.' ROLLBACK TRANSACTION END /* * PREVENT INSERTS IF NO MATCHING KEY IN 'tblSmetki' */ IF (SELECT COUNT(*) FROM inserted) != (SELECT COUNT(*) FROM tblSmetki, inserted WHERE (tblSmetki.ID_Smetka = inserted.ssSmetka)) BEGIN RAISERROR 44447 'The record can''t be added or changed. Referential integrity rules require a related record in table ''tblSmetki''.' ROLLBACK TRANSACTION END