Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TRIGGER dbo.UA_TRIGGER_PAGAMENTO
- ON dbo.PagamentoSet
- AFTER UPDATE
- AS
- Declare @vEstado varchar(20);
- Declare @vIdSocio int;
- BEGIN
- SET NOCOUNT ON;
- Set @vEstado = (SELECT Estado FROM inserted);
- Set @vIdSocio = (SELECT Socio_Id FROM inserted);
- IF (@vEstado = 'PAGO') THEN
- UPDATE SocioSet
- Set Atualizado = 'True'
- WHERE Id = @vIdSocio;
- END IF;
- END
- GO
- Msg 156, Level 15, State 1, Procedure UA_TRIGGER_PAGAMENTO, Line 15
- Incorrect syntax near the keyword 'THEN'.
- Msg 156, Level 15, State 1, Procedure UA_TRIGGER_PAGAMENTO, Line 23
- Incorrect syntax near the keyword 'END'.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement