在系統登入時有時需要檢查輸入的大小寫
尤其是帳號、password的檢查
感謝kevin提供一個好方法
CREATE PROCEDURE Comm_CheckUserLogin
@employee_no nvarchar(15) , @password nvarchar(8)
AS
SELECT employee.emp_employee_no
FROM employee
WHERE employee.emp_employee_no = @employee_no AND
CAST(employee.emp_employee_password AS varbinary)=CAST(@password AS varbinary)
透過casting成binary的方式來檢查…
尤其是帳號、password的檢查
感謝kevin提供一個好方法
CREATE PROCEDURE Comm_CheckUserLogin
@employee_no nvarchar(15) , @password nvarchar(8)
AS
SELECT employee.emp_employee_no
FROM employee
WHERE employee.emp_employee_no = @employee_no AND
CAST(employee.emp_employee_password AS varbinary)=CAST(@password AS varbinary)
透過casting成binary的方式來檢查…
全站熱搜
留言列表