CREATE PROCEDURE s_user_getLoginUserNameAndPwd
    
@userName varchar(50),
    
@userPassword varchar(50)
AS
SELECT 
    
*
FROM sUser 
WHERE 
    
convert(varbinary,userName)=convert(varbinary,@userName)
AND
     
[userPassword]=@userPassword
GO
posted on 2007-09-12 12:20  jalor  阅读(1890)  评论(0)    收藏  举报