Sql Trigger Örneği

CREATE TRIGGER BELGENO
ON LG_999_01_INVOICE
AFTER INSERT,UPDATE
AS

DECLARE @INVLOGI INT
DECLARE @INVDOCODE NVARCHAR(11)
DECLARE @TRCODE SMALLINT

SELECT @INVLOGI=LOGICALREF FROM inserted
SELECT @INVDOCODE=DOCODE FROM inserted
SELECT @TRCODE=TRCODE FROM inserted

IF (@TRCODE=8)

BEGIN
UPDATE LG_999_01_INVOICE SET DOCODE=” WHERE LOGICALREF=@INVLOGI
END