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

Popular posts from this blog

Fix network printer error 0x0000709

When printing in the network, sometimes you see the error "Operation could not be completed (error 0x00000709). Double click the printer name and make sure that the printer is connected to the network".  Here we show how to fix the error: Open Windows Control Panel Open Credential Manager Choose Windows Credentials Click Add a Windows credential Internet or network address: input the computer name which share the printer User name: input "guest" Password: leave it blank Then click OK and reconnect the shared printer Do not need: uninstall Windows updates; change Windows registry... This maybe applied for error: 0x00000005, 0x0000011b... Watch the step by step video on here: