使用Bein Transaction與Commit Transaction
delete from TableName where ID in (select top 1000 ID from TableName order by ID...
單靠SQL應該是辦不到的 這個問題,微軟有相關的說明 請參考