1. While
DECLARE @cnt INT
SET @cnt = 0
WHILE @cnt < 10
BEGIN
PRINT @cnt
SET @cnt = @cnt + 1
END;
SET @cnt = 0
WHILE @cnt < 10
BEGIN
PRINT @cnt
SET @cnt = @cnt + 1
END;
DECLARE @cnt INT
SET @cnt = 0
WHILE @cnt <= 100
BEGIN
if @cnt >= 80
begin
print @cnt
print 'NIlai A'
end
else if @cnt >= 60 and @cnt < 80
begin
print @cnt
print 'NIlai B'
end
else
begin
print @cnt
print 'Nilai C'
end
SET @cnt = @cnt + 10
END
2. While Break
DECLARE @cnt INT
SET @cnt = 0
WHILE @cnt < 10
BEGIN
PRINT @cnt
SET @cnt = @cnt + 1
if @cnt = 7
BREAK
END
