how to valid user in stored procedure? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

how to valid user in stored procedure?

Author

Topic

samsun125
Yak Posting Veteran

63 Posts

Posted - 2008-11-28 : 01:57:24

Hi all,
my doubt is i want to validate user with his username and password and i want to return tokenkey (if he is valid user)so i used this procedure .
but i am getting this error.

Msg 156, Level 15, State 1, Procedure validuser, Line 13
Incorrect syntax near the keyword 'IF'.
Msg 156, Level 15, State 1, Procedure validuser, Line 21
Incorrect syntax near the keyword 'else'.

procedure:

ALTER procedure [iphone].[validuser] --sam,sam
(
@username varchar(100),
@password varchar(100)
--@TokenNo int OUTPUT
)
as
begin
DECLARE @TempTokenKey varchar(100)
DECLARE @TESTResult xml
Set @TempTokenKey=IF EXISTS(select TokenKey from dbo.tbllogin where username=@username and password=@password)
print @TempTokenKey
--Set @TempTokenKey=(select TokenKey from iphone.temp_UserProfiles where FirstName=@FirstName)

BEGIN
SET @TESTResult='<validusers><validuser="@TempTokenKey" ></validuser></validusers>' --Add the main tag and element tag here
SELECT @TESTResult
END
else
BEGIN
SET @TESTResult='<SecureWebServices><SecureWebService Result="0"></SecureWebService></SecureWebServices>' --Add the main tag and element tag here
SELECT @TESTResult
END
end

can u please help me

Thanks & Regards
RamaDevi.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-11-28 : 02:56:08

Like this?

ALTER PROCEDURE iphone.validuser
(
	@username varchar(100),
	@password varchar(100)
	@TokenNo int OUTPUT
)
AS

SET NOCOUNT ON

SELECT	@TokenNo = TokenKey
FROM	dbo.tbllogin
WHERE	username = @username
	and password = @password

IF @TokenNo IS NULL
	SET @TESTResult = '<SecureWebServices><SecureWebService Result="0"></SecureWebService></SecureWebServices>'
ELSE
	SET @TESTResult = '<validusers><validuser>' + CAST(@TokenNo AS VARCHAR(11)) + '</validuser></validusers>'

E 12°55'05.63"
N 56°04'39.26"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources