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
Updated On: 05.04.01