Advertisement
Guest User

Untitled

a guest
Jun 27th, 2019
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.18 KB | None | 0 0
  1. declare @ids table (id int primary key)
  2.  
  3. insert into @ids (id)
  4. select 1 union all
  5. select 2 union all
  6. ...
  7. select 3000
  8.  
  9. delete from table_name where id in
  10. (select id from @ids)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement