Skip to content

break-transact-sql.md

Latest commit

 

History

History
53 lines (45 loc) · 1.71 KB

break-transact-sql.md

File metadata and controls

53 lines (45 loc) · 1.71 KB
description BREAK (Transact-SQL)
title BREAK (Transact-SQL) | Microsoft Docs
ms.custom
ms.date 11/19/2018
ms.prod sql
ms.prod_service database-engine, sql-database, sql-data-warehouse, pdw
ms.reviewer
ms.technology t-sql
ms.topic reference
f1_keywords
BREAK
BREAK_TSQL
dev_langs
TSQL
helpviewer_keywords
exiting innermost loop [SQL Server]
END keyword
ignored statements
BREAK keyword
ms.assetid 67c30b8d-3f15-41ad-b9a9-a4ced3b2af9f
author cawrites
ms.author chadam
monikerRange >=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current

BREAK (Transact-SQL)

[!INCLUDE sql-asdb-asdbmi-asa-pdw]

BREAK exits the current WHILE loop. If the current WHILE loop is nested inside another, BREAK exits only the current loop, and control is given to the next statement in the outer loop.

BREAK is usually inside an IF statement.

Examples

WHILE (1=1)
BEGIN
   IF EXISTS (SELECT * FROM ##MyTempTable WHERE EventCode = 'Done')
   BEGIN
      BREAK;  -- 'Done' row has finally been inserted and detected, so end this loop.
   END

   PRINT N'The other process is not yet done.';  -- Re-confirm the non-done status to the console.
   WAITFOR DELAY '00:01:30';  -- Sleep for 90 seconds.
END

See Also