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
Post a Comment