i write the procedure for login in this user can give username or emailid for the login. this is my code.... please check is there any change is required for this
ALTER procedure [dbo].[users_login] (@username varchar(50),@password varchar(50),
@emailid varchar(50),@ret int output)
as
begin
select username,password,emailid from users where( username=@username or
emailid=@emailid) and [password]=@password
if(@@rowcount >0)
begin
set @ret=1
end
else
begin
set @ret=0
end
end