store procedure para validar usuario

[Andres95]

Código:

-- En el Stored Procedure
CREATE PROCEDURE ValidaUsuario 
@Usuario nvarchar(50) , 
@Password nvarchar(50),
@Existe bit output 
AS

Set @Existe = 0

If (SELECT count(1) From dbo.Usuarios(nolock) WHERE usuario = @usuario and Password  = @Password ) > 0
Begin
      Set @Existe = 1
End

Y en la pagina (ASP)
set Command1 = Server.CreateObject("ADODB.Command")
With Command1
	.ActiveConnection = MM_Myconn_STRING
	.CommandText = "dbo.ValidaUsuario"
	.Parameters.Append .CreateParameter("@usuario", 200, 1,50, variableLocalUsuario)
	.Parameters.Append .CreateParameter("@password", 200, 1,50,variableLocalPassword)
	.Parameters.Append .CreateParameter("@Existe", 3, 2, 3, 0)
	.CommandType = 4
	.CommandTimeout = 0
	.Prepared = true
	.Execute()
	
	response.write "<BR> Respuesta: " & .parameters(2).value	
		
End With