YOU MUST CREATE A STORED PROCEDURE THAT ADDS A ROW TO THE CUSTOMER...

15. You must create a stored procedure that adds a row to the Customers table and returns the ID of the newly inserted customer. Select the statement that will declare the procedure parameters correctly.A. CREATE PROC AddNewCustomer@ID OUT,@CustomerName varchar(50),@Notes varchar(max)AS…B. CREATE PROC AddNewCustomer@ID int OUT,C. CREATE PROC AddNewCustomer@ID int,@CustomerName varchar(50) OUT,@Notes varchar(max) OUTD. CREATE PROC AddNewCustomerID int OUT,CustomerName varchar(50),Notes varchar(max)