Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select top 1000000
- <your columns>
- into dbo.SubTable1
- from dbo.ReallyBigTable;
- delete dbo.ReallyBigTable
- where ID in (select ID from dbo.SubTable1);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement