Delete large number of rows

SELECT 'Starting' --sets @@ROWCOUNT
 WHILE @@ROWCOUNT <>; 0
 DELETE TOP (xxx) MyTable
0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *