Skip to main content

Return BOOL (True/False) values in MS SQL Server store procedure

When working with Microsoft SQL Server, we sometimes want to check some conditions and return True/False values in a store procedure. To do this, we will make a store with an output as BIT type.



    • Create store procedure like this:



[sql]CREATE PROCEDURE check_condition
-- Add the parameters for the stored procedure here
@check_param INT
AS
BEGIN
DECLARE @flag BIT --flag to return, 0: false, 1: true
SET NOCOUNT ON;
--Check condition here
IF @check_param = 0
SET @flag = 0;
ELSE
SET @flag = 1;
END
SELECT @flag;[/sql]


    • How to catch the result, just use this statement:



[sql]DECLARE @return_value int
EXEC @return_value = dbo.check_condition
@check_param = 1
SELECT 'Return Value' = @return_value[/sql]
That's all.
Wish succeed!

Comments