Hi,

I want to check whether the username and password are exists in the database or not using the Stored Procedure in SQL server. Can anyone give me an idea to do this.

__________________
The OXYGEN
Delivers edgy, intelligent Technology to all...

Hi,
Hope this helps..

CREATE PROCEDURE [trainee].[empinfologin]
(@username varchar(20), @password varchar(20), @values int output)
AS
declare @user varchar(20)
declare @pass varchar(20)
declare @result varchar(40)

BEGIN
select @user=username, @pass=password from empinfo
where username=@username and password=@password
if @user = @username and @pass = @password
begin
set @result='Success'
set @values=1
return @values
end
else
begin
select @user=username, @pass=password from empinfo where
username=@username
if @user=@username and @pass!=@password
begin
set @result='Incorrect Password'
set @values=2
return @values
end
else
SET @result='User does not exist'
set @values=3
return @values
end
END

__________________
S.Balasubramanian
Nothing is impossible