usp_selectmanagername.sql

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

CREATE PROCEDURE usp_SelectManagerName
(
   @ManagerID     UNIQUEIDENTIFIER,
   @ManagerName   VARCHAR(61) OUTPUT
)
AS

SELECT @ManagerName = FirstName + ' ' + LastName
FROM Users
WHERE UserID = @ManagerID