T-SQL Stored Procedure with OUTPUT Parameters

TSQLOutput

/*
Unit Test:

DECLARE @id int;
DECLARE @FruitName_OUT NVARCHAR(50);
DECLARE @FruitColor_OUT NVARCHAR(50);
DECLARE @FruitGrowsOn_OUT int;
DECLARE @FruitIsYummy_OUT bit;

EXECUTE dbo.[GetFruitByID] 1, @FruitName_OUT OUTPUT, @FruitColor_OUT OUTPUT, @FruitGrowsOn_OUT OUTPUT, @FruitIsYummy_OUT OUTPUT

PRINT @FruitName_OUT;
PRINT @FruitColor_OUT;
PRINT @FruitGrowsOn_OUT;
PRINT @FruitIsYummy_OUT;

*/
CREATE PROCEDURE [dbo].[GetFruitByID]
	@id int,
	@FruitName NVARCHAR(50) OUTPUT,
	@FruitColor NVARCHAR(50) OUTPUT,
	@FruitGrowsOn int OUTPUT,
	@FruitIsYummy bit OUTPUT
AS 
	SET NOCOUNT ON;

	SELECT @FruitName = [FruitName], @FruitColor = [FruitColor], @FruitGrowsOn = [FruitGrowsOn], @FruitIsYummy = [FruitIsYummy]
	FROM [dbo].[Fruit]
	WHERE Id = @id;

RETURN 0