bolo17

Azure SQL Database Syntax

Aug 25th, 2020
158
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.48 KB | None | 0 0
  1.  Azure SQL DATABASE Syntax  
  2. -- Trigger on an INSERT, UPDATE, or DELETE statement to a table or view (DML Trigger)  
  3.  
  4. CREATE [ OR ALTER ] TRIGGER [ schema_name . ]trigger_name  
  5. ON { TABLE | VIEW }  
  6.  [ WITH <dml_trigger_option> [ ,...n ] ]  
  7. { FOR | AFTER | INSTEAD OF }  
  8. { [ INSERT ] [ , ] [ UPDATE ] [ , ] [ DELETE ] }  
  9.   AS { sql_statement  [ ; ] [ ,...n ] [ ; ] > }  
  10.  
  11. <dml_trigger_option> ::=  
  12.         [ EXECUTE AS Clause ]  
  13. GET link:https://ouo.io/FXetB9
Add Comment
Please, Sign In to add comment