Thursday, March 27, 2008

stored procdure for case senstive password

CREATE PROCEDURE [dbo].[CheckUserLogin] (
-- This sp is used for case senstive password
@username varchar(200),
@password varchar(200) )
AS
SELECT clientId FROM Userlogin WHERE username=@username AND CAST(password AS VARBINARY(999))= CAST(@password AS VARBINARY(999))

No comments: