text: -- ================================================
  -- Template generated from Template Explorer using:
  -- Create Procedure (New Menu).SQL
  --
  -- Use the Specify Values for Template Parameters 
  -- command (Ctrl-Shift-M) to fill in the parameter 
  -- values below.
  --
  -- This block of comments will not be included in
  -- the definition of the procedure.
  -- ================================================
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  -- =============================================
  -- Author:		Adriel Yeung
  -- Create date: 26/2/2021
  -- Description:	Example of a stored procedure to select data
  -- =============================================
  CREATE PROCEDURE [dbo].[spPrizes_Insert] 
  	-- Add the parameters for the stored procedure here
  	@PlaceNumber int,
  	@PlaceName nvarchar(50),
  	@PrizeAmount money,
  	@PrizePercentage float,
  	@id int = 0 output
  AS
  BEGIN
  	-- SET NOCOUNT ON added to prevent extra result sets from
  	-- interfering with SELECT statements.
  	SET NOCOUNT ON;
  
      -- Insert statements for procedure here
  	INSERT INTO dbo.Prizes (PlaceNumber, PlaceName, PrizeAmount, PrizePercentage)
  	VALUES (@PlaceNumber, @PlaceName, @PrizeAmount, @PrizePercentage);
  
  	-- In the current scope (this stored procedure call -- insert statement), fetch the identity of this transaction
  	SELECT @id = SCOPE_IDENTITY();
  END
  GO
  