Logo Trigger
CREATE TRIGGER [dbo].[KDVMUHAFIYET_031]ON [dbo].[LG_031_01_STLINE]AFTER INSERT, UPDATEASBEGIN DECLARE @CLIENTREF AS INTDECLARE @LREF AS INTDECLARE @FTTIP AS INTDECLARE @STFICHEREF AS INTDECLARE @UNVAN AS NVARCHAR(50)DECLARE @VATEXCEPTCODE AS INTDECLARE @VATEXCEPTREASON AS NVARCHAR(50)SELECT @LREF = LOGICALREF, @FTTIP = TRCODE , @STFICHEREF = STFICHEREF FROM inserted if @STFICHEREF > 0 AND @FTTIP = 8 OR @VATEXCEPTCODE > 0 begin SELECT @VATEXCEPTCODE…
Devamı
Son yorumlar