SQL SP [modified]

[daku1]

how to create sp for username and password -- modified at 23:54 Thursday 8th March, 2007

[N a v a n e e t h]

make your question more clear

daku1 wrote:

how to create sp for username and password

Do you want to create a procedure that can validate user name and password ? Then it could be something like this

CREATE PROCEDURE ValidateProcedure
(
@Username varchar(20),
@Password varchar(20)
)

AS

Select * From UserTable Where UserNameColumn = @Username and PasswordColumn = @Password

GO

Get the result in some reader. If the reader has records then u r login is authenticated. If you want to make your password case sensitive then go through this snippet http://www.w3hearts.com/showsnippet.aspx?show=22

Cheers Navaneeth!! www.w3hearts.com