SQL SERVER中如何使用输出参数

话不多说，直接贴上代码

DROP PROCEDURE TEST;

CREATE PROCEDURE TEST(
 @param VARCHAR(10),
 @output VARCHAR(10) OUTPUT
)
AS

BEGIN
 SET NOCOUNT ON;
 SELECT * FROM Customers WHERE customerid=@param;
 SET @output='qqq';
END;

DECLARE @a VARCHAR(10);
EXEC TEST 'FISSA',@a OUTPUT;
SELECT @a;