Advertisement
Guest User

Untitled

a guest
Oct 2nd, 2014
190
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.15 KB | None | 0 0
  1. select top 1000000
  2. <your columns>
  3. into dbo.SubTable1
  4. from dbo.ReallyBigTable;
  5.  
  6. delete dbo.ReallyBigTable
  7. where ID in (select ID from dbo.SubTable1);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement