Trigger dbo.L_GLJob_ITrig

CREATE TRIGGER L_GLJob_ITrig ON L_GLJob FOR INSERT AS

/ *
* PREVENT NULL VALUES IN ´DeptCode´
* /
IF (SELECT Count(*) FROM inserted WHERE DeptCode IS NULL) > 0
BEGIN
RAISERROR 44444 ´Field ´´DeptCode´´ cannot contain a null value.´
ROLLBACK TRANSACTION
END