CREATE TRIGGER [dbo].[TRG_020_02_STFICHE_KAGIT_IRS]
ON [dbo].[LG_020_02_STFICHE]
AFTER INSERT
AS
BEGIN
SET NOCOUNT ON;
DECLARE @LOGICALREF INT
SELECT
@LOGICALREF = LOGICALREF
FROM INSERTED
UPDATE LG_020_02_STFICHE SET EDESPATCH = 0 WHERE LOGICALREF = @LOGICALREF

END

GO