how to validate 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 validate user in stored procedure?

Author

Topic

samsun125
Yak Posting Veteran

63 Posts

Posted - 2008-11-06 : 07:30:39

Hi all,

I have one query , i want to validate users using sp

if he is a valid user i want do display 1 and he is not a valid user means i want to display 0 in xml format

i wrote like this :please check it

ALTER procedure [dbo].[login]
(
@username varchar(100),
@password varchar(100)
)
as
begin
DECLARE @Result xml
select * from dbo.tbllogin where username=@username and password=@password
if @@ERROR>0
BEGIN
SET
@Result='<securewebservices><securewebservice Result="0"></securewebservice></securewebservices>' SELECT @Result
END
else
BEGIN
SET @Result='<securewebservices><securewebservice Result="1"></securewebservice></securewebservices>' SELECT @Result
END

end

Thanks & Regards
RamaDevi.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-06 : 07:36:14

create an output parameter of type bit and return value as 0 or 1 after retrieving data from table.

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2008-11-06 : 07:45:36

another way: (keep in mind that this is a VARCHAR that looks like XML - it's not xml datatype. But that seems to be what you're looking for)


if exists (select username from tbllogin where username = @username and password = @password)
begin
   set @result = '<securewebservices><securewebservice Result="1"></securewebservice></securewebservices>'
end
else
begin
    set @result = '<securewebservices><securewebservice Result="0"></securewebservice></securewebservices>'
end

select @result

Be One with the Optimizer
TG

samsun125
Yak Posting Veteran

63 Posts

Posted - 2008-11-06 : 08:13:13

Hello friend ,

Thankyou very much

i changed the sp as mentioned above example

i got result

Regards
RamaDevi

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources