T-SQL Never ending DELETE

set rowcount 10000
while 1=1
    begin
      DELETE FROM customers WHERE cust_num LIKE '%8009______'
      IF @@rowcount = 0
          BREAK
      ELSE
          CHECKPOINT
    end

Source: databasejournal.com

Similar codes

-1 vote97 views1 answer
How to switch user in mysql
SQL
0 vote118 views1 answer
Least spark sql
SQL
1 vote110 views1 answer
Set autoincrement to 0
SQL
0 vote110 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
0 vote97 views1 answer
Uninstall mysql ubuntu 18.04 stackoverflow
SQL
0 vote99 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
0 vote105 views1 answer
Oracle service name view
SQL
0 vote128 views1 answer
Sql quary stuf
SQL
0 vote103 views1 answer
Heavy table in mysql
SQL
0 vote115 views1 answer
Oracle winter time change
SQL