Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.24 KB | None | 0 0
  1. create trigger
  2.     InsertTriggerTest2Table
  3. on
  4.     dbo.triggerTest
  5. for insert
  6. as
  7.     if((select type from inserted) <> 35)
  8.     begin
  9.         return
  10.     end
  11.     insert into triggerTest2
  12.     (
  13.         Text2,
  14.         type
  15.     )
  16.     select
  17.         Text,
  18.         type
  19.     from inserted
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement