「SQL Server」while文でループを抜けるサンプル
書式
IF 条件式
BREAK
使用例
CREATE PROCEDURE dbo.SAMPLE
AS
DECLARE @cnt INT
SET @cnt = 3
WHILE @cnt < 10
BEGIN
IF @cnt = 8
BREAK
SET @cnt = @cnt + 1
END
PRINT @cnt
CREATE PROCEDURE dbo.SAMPLE
AS
DECLARE @cnt INT
SET @cnt = 3
WHILE @cnt < 10
BEGIN
IF @cnt = 8
BREAK
SET @cnt = @cnt + 1
END
PRINT @cnt
CREATE PROCEDURE dbo.SAMPLE AS DECLARE @cnt INT SET @cnt = 3 WHILE @cnt < 10 BEGIN IF @cnt = 8 BREAK SET @cnt = @cnt + 1 END PRINT @cnt
実行結果
8