Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Create trigger maakonnaUuendus
- ON maakond
- FOR UPDATE
- AS
- INSERT into logi(aeg, toiming, andmed)
- SELECT GETDATE(), 'andmed on muudetud',
- CONCAT('vana maakond ', deleted.maakond, ' on muudetud ', inserted.maakond )
- from deleted
- INNER JOIN inserted ON deleted.maakondID=inserted.maakondID
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement