usp_validatelogin.sql

来自「Beginning VB.NET DatabasesAll_Code.rar」· SQL 代码 · 共 11 行

CREATE PROCEDURE usp_ValidateLogin
(
   @LoginName   VARCHAR(15),
   @Password    VARCHAR(30)
)
AS
SELECT RoleName, UserID, FirstName + ' ' + LastName AS UserName, Status
FROM Users
JOIN Roles ON Users.RoleID = Roles.RoleID
WHERE UPPER(LoginName) = UPPER(@LoginName) AND Password = @Password