GetOrderProducts.sql

USE [MyDB]
GO

CREATE PROCEDURE [dbo].[usp_GetOrderProducts]  

AS

 BEGIN

	--Declare Local Variables
	DECLARE		@Procedure_Name     varchar(100),
                @Error_Num          int,
                @Error_Message      varchar(1000)

	BEGIN TRY


	SELECT 
	  [OrderId]
      ,[ProductId]
      ,[UnitPrice]
      ,[Quantity]
  FROM [MyDB].[dbo].[OrderItem]

		
	END TRY

	BEGIN CATCH

		SET @Error_Num = ERROR_NUMBER()
		SET @Error_Message = ERROR_MESSAGE()
	    
		RAISERROR(@Error_Message,15,1,@Procedure_Name) WITH NOWAIT, SETERROR
	    
	END CATCH

END