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

Insert Google Search box into blog/website

Normally, every  blog/website has a search function which supports everyone to easily browse the site contents. But it maybe not really useful and effective. Then Google Custom Search is a brilliant choice for you. How to get it?

Access Facebook.com with Google DNS and hosts file

Facebook is now the most popular social network. You have many friends and many informations which need to be check on it. But a day, you can't access Facebook or can't post an image. You can resolve this problem by simple steps:

Integrate blogspot blogger blog with Dot TK free domain

Blogspot or Blogger is a blog service from Google. This service provides us many functions to make a small website as creating a blog, posting, commenting, . . . But there is a thing which might cause you dissatisfy. That's the blog address is too long, like http://www.your-tips-tricks.blogspot.com . If you own a short Dot TK domain , then your problems will be solved.