usp_selectmanageremployees.sql

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

CREATE PROCEDURE usp_SelectManagerEmployees
(
   @ManagerID   UNIQUEIDENTIFIER
)
AS
SELECT UserID, FirstName + ' ' + LastName AS EmployeeName
FROM Users
Where ManagerID = @ManagerID
ORDER BY EmployeeName