How to return bool from stored proc

user_396382 0
Viewed 64439

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?

stored-procedures sql-server
4 Answers
DECLARE @bitVariable bit     
SELECT @bitVariable = columnName FROM table WHERE id=id
user_76117700
Related