6K4Dj72P

1CREATE TRIGGER [dbo].[Payments_PreventBatchThatAreNotP] ON [dbo].[Payments]
2AFTER INSERT
3AS
4SET NOCOUNT ON;
5
6IF EXISTS (
7        SELECT *
8        FROM inserted p
9        JOIN dbo.Batches b ON b.batch_id = p.batch_id
10            AND b.batch_type <> 'P'
11        )
12BEGIN
13    RAISERROR ('Batch type not equal "P" - transaction rolled back',16,1);
14
15    ROLLBACK
16END
17
18
19GO
20
21ALTER TABLE [dbo].[Payments] ENABLE TRIGGER [Payments_PreventBatchThatAreNotP]
22GO