Creating a Password Retrieval Stored Procedure

I would like to create a stored procedure to pass a login name and password
to and have it verify the info and return a few fields of data back to the
calling function from a javascript page. I have tried a few things but can'
t
seem to verify the data and return a value to verify the data.One method is to use NOT EXISTS:
CREATE PROC MyProc
@.UserID varchar(128),
@.Password varchar(128)
AS
SET NOCOUNT ON
IF NOT EXISTS
(
SELECT MyData
FROM Users
WHERE UserID = @.UserID AND
Password = @.Password
)
BEGIN
RAISERROR ('Invalid user or password', 1, 0)
END
SELECT MyData FROM MyTable
GO
Hope this helps.
Dan Guzman
SQL Server MVP
"EvanK" <EvanK@.discussions.microsoft.com> wrote in message
news:210A9660-5874-4AA0-9DF9-1CFE9487868B@.microsoft.com...
>I would like to create a stored procedure to pass a login name and password
> to and have it verify the info and return a few fields of data back to the
> calling function from a javascript page. I have tried a few things but
> can't
> seem to verify the data and return a value to verify the data.|||I changed the code as follows:
CREATE PROCEDURE dbo.MM_Chk_User
@.UserID varchar(128),
@.Password varchar(128)
AS
SET NOCOUNT ON
IF NOT EXISTS
(
SELECT First_Name, Last_Name
FROM LogonNames
WHERE Name = @.UserID AND
Password = @.Password
)
BEGIN
RAISERROR ('Invalid user or password', 1, 0)
END
SELECT First_Name, Last_Name
FROM LogonNames
WHERE Name = @.UserID AND
Password = @.Password
GO
I get the following error
[SQL Server]Invalid value 0 for state. Valid ranges is from 1 to 127
"Dan Guzman" wrote:

> One method is to use NOT EXISTS:
> CREATE PROC MyProc
> @.UserID varchar(128),
> @.Password varchar(128)
> AS
> SET NOCOUNT ON
> IF NOT EXISTS
> (
> SELECT MyData
> FROM Users
> WHERE UserID = @.UserID AND
> Password = @.Password
> )
> BEGIN
> RAISERROR ('Invalid user or password', 1, 0)
> END
> SELECT MyData FROM MyTable
> GO
>
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "EvanK" <EvanK@.discussions.microsoft.com> wrote in message
> news:210A9660-5874-4AA0-9DF9-1CFE9487868B@.microsoft.com...
>
>