title: How to return bool from stored proc
body: <p>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.</p>
  
  <pre><code>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
  </code></pre>
  
  <p>I'm unsure however how to write one to return a boolean value.</p>
  
  <p>Can somebody help? Is it a bit value?</p>