Guest User

Untitled

a guest
Oct 22nd, 2018
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.22 KB | None | 0 0
  1. create table OS (
  2. num_os integer PK,
  3. sync_data varchar(1)
  4. )
  5.  
  6. CREATE TRIGGER TGR_OS_SYNC
  7. ON OS
  8. FOR INSERT
  9. AS
  10. BEGIN
  11. DECLARE
  12. @NUMOS integer,
  13.  
  14. UPDATE OS SET SYNC_DATA = 0
  15. WHERE num_os = @NUMOS
  16. END
  17. GO
Add Comment
Please, Sign In to add comment