kevinya

從微軟參考來的

以下是PROCEDUE的部分

use Northwind
CREATE PROCEDURE uspProcReturnValue
@LastName nvarchar(50),
@Title nvarchar(100) OUTPUT
AS  

    SET NOCOUNT ON;            
    SELECT TOP 1  @Title=Title FROM Employees
    where LastName = @LastName
RETURN
GO

以下是引用此PROCEDURE的部分

DECLARE @outPutTitle varchar(100) 
exec uspProcReturnValue 'Davolio',@Title = @outPutTitle OUTPUT
print(@outputTitle);