Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ALTER TRIGGER dbo.TriggerUpdate ON dbo.t_pedidos FOR UPDATE
- AS
- SET NOCOUNT ON
- INSERT INTO dbo.logTransacciones
- (PK,ValorNuevo,ValorOriginal,FechaTrn, Usuario)
- SELECT I.id,I.descripcion_anexo,D.descripcion_anexo, getdate(), system_user
- FROM INSERTED I
- INNER JOIN DELETED D ON
- I.id = D.id
- AND I.descripcion_anexo <> D.descripcion_anexo
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement