Sql

Search

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

Comment

PREVIOUS	NEXT

Code Example
Sql :: where clause for clob in oracle
Sql :: array aggre distinct postgres
Sql :: SQL isnumeric DB2
Sql :: sql trying to delete database in use
Sql :: mysql default -temp password
Sql :: mysql select database
Sql :: check if table is Temporal
Sql :: sqlite create record
Sql :: how to do an average on a count sql
Sql :: date datatype in livesql
Sql :: how to replace null values in sql
Sql :: sqlite löschen einer tabelle
Sql :: psql concat string and int
Sql :: limit and offset in stored procedure mssql
Sql :: Inserting data into different tables at once in oracle sql
Sql :: triggers in mysql example
Sql :: mysql inner join
Sql :: postgresql populate data random
Sql :: psql store procedure-return multiple table values
Sql :: identify rows with 2 same column value and delete duplicate mysql
Sql :: drop procedure postgres
Sql :: mysql not
Sql :: t sql first and last day of week
Sql :: sql full outer join
Sql :: sqlalchemy orm duplicate
Sql :: sql delete table
Sql :: select columns from 2 tables with foreign key
Sql :: install mssql on ubuntu
Sql :: update a column with another column in same table mysql
Sql :: ruby sqlite

Search

SQL

T-SQL Never ending DELETE

ADD CONTENT