Home >> Dababase Interview Questions >> Sql Server 2000 Query

Syntax of While Statement in SQL Query

Posted on November 16th , 2009 by Admin

DECLARE @flag INT

SET @flag = 0

WHILE @flag <4

BEGIN

SET @flag = @flag + 1

PRINT 'The flag : ' + CAST(@flag AS CHAR)

END

Output is :

The flag : 1

The flag : 2

The flag : 3