Advertisement
Guest User

Untitled

a guest
Apr 26th, 2019
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. Create trigger maakonnaUuendus
  2. ON maakond
  3. FOR UPDATE
  4. AS
  5. INSERT into logi(aeg, toiming, andmed)
  6. SELECT GETDATE(), 'andmed on muudetud',
  7. CONCAT('vana maakond ', deleted.maakond, ' on muudetud ', inserted.maakond )
  8. from deleted
  9. INNER JOIN inserted ON deleted.maakondID=inserted.maakondID
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement