Answers for "T-SQL Never ending DELETE"

SQL
0

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
Posted by: Guest on November-08-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language