SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
-- Exec BuscaCliente 'Juanito'
CREATE PROCEDURE BuscaCliente
@Cliente varchar(20)
AS
Declare @Result bit
Declare @Nombre varchar(20)
Select @Result = 1, @Nombre = Cliente
From Clientes
Where Cliente = @Cliente
Select IsNull(@result,0) as Resultado, @Nombre as Nombre
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO