如何从存储过程返回布尔值 [英] How to return bool from stored proc

问题描述

我正在研究如何编写一个返回布尔值的存储过程.我开始编写以下返回 int 的代码.

I'm trying to work out how to write a store procdure which returns a boolean value. I started off writing the following one which returns an int.

USE [Database]
GO
/****** Object:  StoredProcedure [dbo].[ReturnInt]    Script Date: 09/30/2010 09:31:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[ReturnInt]  AS
RETURN 3

但是我不确定如何编写一个返回布尔值的方法.

I'm unsure however how to write one to return a boolean value.

有人可以帮忙吗?是不是有点值?

Can somebody help? Is it a bit value?

推荐答案

你不能.没有布尔数据类型，过程返回码只能是 int.你可以返回一个 bit 作为输出参数.

You can't. There is no boolean datatype and the procedure return code can only be an int. You can return a bit as an output parameter though.

CREATE PROCEDURE [dbo].[ReturnBit] 
@bit BIT OUTPUT
AS
    BEGIN
    SET @bit = 1
    END

并调用它

DECLARE @B BIT
EXEC [dbo].[ReturnBit] @B OUTPUT
SELECT @B

这篇关于如何从存储过程返回布尔值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！