SQL Triggers

ALTER TRIGGER [STK35].[OrdFsstkCntUpd]

ON [STK35].[ORDFS]

AFTER UPDATE

AS

declare @OrdFsStkCnt as decimal(12,2), @OrdfsIdPrd AS CHAR(18), @MSAG AS CHAR(100)

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

select @OrdFsStkCnt=OrdFsStkCn, @OrdfsIdPrd =OrdfsIdPrd FROM inserted

SET @MSAG = 'UPD' + @OrdfsIdPrd + ' - ' + CAST(@OrdFsStkCnt AS CHAR)

INSERT INTO [dbo].[DebugTrigger]([sqltxt]) values (@MSAG )



END