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
DECLARE @flag BIT --flag to return, 0: false, 1: true
--Check condition here
IF @check_param = 0
SET @flag = 0;
SET @flag = 1;
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!


Popular posts from this blog

Turn off AutoPlay on Windows

On Windows, when you insert an USB or a CD/DVD into your computer, they are usually opened automatically. So the computer maybe infected autorun virus. To avoid that, you should turn off AutoPlay function.

Create Wordpress page template

When creating a new page in Wordpress, we usually have a choice for the page template. It's call Default template . However, we sometimes need to make a new page with a new appearance. Then another page template is needed. Instead of downloading a shared page template from internet, we can create a new page template by below instructions.