While Loop for deletes

Tech Talk Databases
1

Here is a quick way to use the delete and loop throughout the records without increaing the transactions log to much:

WHILE @@ROWCOUNT > 0
	DELETE	TOP (1000)
	FROM orderAudit where userid='sql_query_chg_price'