usp_selectuser.sql

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

CREATE PROCEDURE usp_SelectUser
(
   @UserID   UNIQUEIDENTIFIER
)
AS
SELECT UserID, LoginName, Password, FirstName, LastName,
   Email, Phone, Status, GroupID, RoleID, ManagerID, LastUpdateDate
FROM Users
WHERE UserID = @UserID