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 |
| |||
| 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 |
| Sponsored Links |
![]() |
| Thread Tools | |
| Display Modes | |
| |
LinkBacks (?)
LinkBack to this Thread: http://www.discussweb.com/database-support/2275-username-password-verfication-sql-server-2005-itself-using-stored-procedure.html | |||
| Posted By | For | Type | Date |
| Username,Password verfication in SQL Server 2005 itself using ... | Web Hosting | This thread | Refback | 01-11-2008 05:35 AM |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How can we encrypt the username and password using PHP? | sundarraja | PHP Programming | 3 | 05-15-2008 07:29 AM |
| Username and Password verification in SQL stored procedure. | oxygen | Database Support | 1 | 12-23-2007 09:43 PM |
| Can a stored procedure call itself or recursive stored procedure? How many level SP n | H2o | Database Support | 1 | 08-03-2007 10:55 AM |
| How to Send Mail Using Stored Procedure in MS SQL SERVER 200x?? | Gopisoft | Database Support | 1 | 07-17-2007 09:43 AM |
| How Can we change the logon password in SQL Server 2005 ? | mobilegeek | Database Support | 1 | 07-16-2007 02:39 AM |