Skip to main content
May 31, 2014

As developers, we often work with SQL Server stored procedures. The SQL Server stored procedures can have many purposes. One of them is to perform some logical operations and to return true or false value. The problem is that there is no boolean datatype so the only way is that stored procedure returns bit datatype.

Here is an example of stored procedure that will return bit value that could be used instead of boolean:

USE [Database]
GO
 
SET ANSI_NULLS ON
GO
 
SET QUOTED_IDENTIFIER ON
GO
 
CREATE PROCEDURE [dbo].[spReturnValue]
AS
    DECLARE @result BIT
    
    SET @result = 1
    
    RETURN (@result)
    
GO

In order to call the stored procedure use the following SQL code:

USE [Database]
GO
 
DECLARE @return_value BIT
 
EXEC @return_value = [dbo].[spReturnValue]
 
SELECT 'Return Value' = @return_value
 
GO