This is a discussion on Username,Password verfication in SQL Server 2005 itself using stored procedure within the Database Support forums, part of the Web Development category; Username and Password verification in SQL stored procedure. Goals: This stored procedure is used to verify username and password itself. ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| |||
| |||
| Username and Password verification in SQL stored procedure. Goals: This stored procedure is used to verify username and password itself. Steps: 1) Create a stored procedure. 2) copy the following code. 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 |
![]() |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| [ADO.NET + VB 2005] Master Detail insert - one stored procedure or divided ? | bluesky | ASP and ASP.NET Programming | 6 | 07-13-2009 02:08 AM |
| Username and Password verification in SQL stored procedure. | oxygen | Database Support | 1 | 12-23-2007 08:43 PM |
| Can a stored procedure call itself or recursive stored procedure? How many level SP n | H2o | Database Support | 1 | 08-03-2007 09:55 AM |
| How to Send Mail Using Stored Procedure in MS SQL SERVER 200x?? | Gopisoft | Database Support | 1 | 07-17-2007 08:43 AM |
| How Can we change the logon password in SQL Server 2005 ? | mobilegeek | Database Support | 1 | 07-16-2007 01:39 AM |
Our Partners |