BEGIN
-- SQL statements here
SELECT * FROM Employees;
END;
CREATE PROCEDURE GetEmployeeCount
AS
BEGIN
DECLARE @Count INT;
SET @Count = (SELECT COUNT(*) FROM Employees);
RETURN @Count;
END;
DECLARE @i INT = 1;
WHILE @i <= 10
BEGIN
IF @i = 5
BREAK;
PRINT 'Value: ' + CAST(@i AS NVARCHAR(2));
SET @i = @i + 1;
END;
BEGIN TRY
-- Some code that may raise an error
RAISEERROR('This is an error message.', 16, 1);
END TRY
BEGIN CATCH
-- Handle the error here
THROW;
END CATCH;
DECLARE @i INT = 1;
WHILE @i <= 5
BEGIN
IF @i = 3
BEGIN
SET @i = @i + 1;
CONTINUE;
END
PRINT 'Value: ' + CAST(@i AS NVARCHAR(2));
SET @i = @i + 1;
END;
BEGIN TRY
-- Code that may cause an error
SELECT 1 / 0;
END TRY
BEGIN CATCH
-- Handle the error here
PRINT 'An error occurred: ' + ERROR_MESSAGE();
END CATCH;
DECLARE @i INT = 1;
LOOP_START:
PRINT 'Value: ' + CAST(@i AS NVARCHAR(2));
SET @i = @i + 1;
IF @i <= 5
GOTO LOOP_START;
WAITFOR DELAY '00:00:05'; -- Wait for 5 seconds
PRINT 'Delay completed.';
DECLARE @Age INT = 25;
IF @Age >= 18
PRINT 'You are an adult.';
ELSE
PRINT 'You are a minor.';
DECLARE @i INT = 1;
WHILE @i <= 5
BEGIN
PRINT 'Value: ' + CAST(@i AS NVARCHAR(2));
SET @i = @i + 1;
END;