yo tengo esto y me funciona muy bien:
Código SQL
[-]
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
-- Exec BuscaCliente 'Juanito'
CREATE PROCEDURE BuscaCliente
@Cliente varchar(20)
AS
Declare @Result bit
If Exists(Select Cliente From Clientes Where Cliente = @Cliente)
Begin
select @Result = 1
end else begin
Select @Result = 0
end
Select @Result as Resultado
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO