Based on the below table, c.r.e.ate a stored procedure 'get_prodLocationId' that will accept the Name of the location as a parameter and display LocationID. Then, execute the procedure using a proper parameter.

 

Object Explorer Connect #Y e Production.Location Columns To LocationID (PK, smallint, not null) Name (Name(nvarchar(50)), not null) CostRate (smallmoney, not null) Availability (decimal (8,2), not null) Modified Date (datetime, not null). Keys Constraints. Triggers Indexes + Statistics X SQLQuery1.sql - D...4H7KGP\samib (57))* X * select from Production. Location 100 % Results 1 2 3 4 5 6 7 8 LocationID 1 2 3 4 5 6 7 10 Messages Name Tool Crib Sheet Metal Racks Paint Shop Paint Storage Metal Storage Miscellaneous Storage Finished Goods Storage Frame Forming CostRate Availability 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 22.50 0.00 0.00 0.00 0.00 0.00 0.00 96.00 ModifiedDate 2008-04-30 00:00:00.000 2008-04-30 00:00:00.000 2008-04-30 00:00:00.000 2008-04-30 00:00:00.000 2008-04-30 00:00:00.000 2008-04-30 00:00:00.000 2008-04-30 00:00:00.000 2008-04-30 00:00:00.000