How to perform repetitive processing : while « Transact SQL « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Transact SQL
  3. while
The syntax of the WHILE statement

WHILE expression
    {statement|BEGIN...END}
    [BREAK]
    [CONTINUE]








20.8.while
20.8.1.How to perform repetitive processing
20.8.2.WHILE @@FETCH_STATUS = 0
20.8.3.This procedure inserts rows by using while loop
20.8.4.Insert 100 rows of data: RAND
20.8.5.While with counter
20.8.6.Use while loop to insert data
20.8.7.While loop controlled by an aggregate function
20.8.8.WHILE with AND operator
20.8.9.A script that tests and adjusts credit amounts with a WHILE loop
20.8.10.Using a Subquery with a Single-Statement WHILE Loop