I am stuck on the question about creating a stored procedure to view the order details given order number.

Transcribed Image Text:

SQLQuery4.sql - LA...CF04F9Q\kaitl (54))* X Inventory Database...CF04F9Q\kaitl (61))* /*create a stored procedure*/ Eluse Inventory; select from REP; select from CUSTOMER; select from ITEM; select from ORDERS; select from ORDER_LINE; /*In the existing query window, create a stored procedure to view the order details given order number*/ /*In the existing query window, create a stored procedure to insert a new order to ORDERS table*/ Fcreate procedure insert_new_order @varl char(5), @var2 date, @var3 char (3) as begin insert into ORDERS values (@var1,@var2,@var3); print 'New order added to the ORDERS table'; end [exec insert_new_order '51700', '11/15/2022', '126; SQLQuery3.sql - LA...CF04F9QV SQLQuery4.sql - LA...CF04F9Q\kaitl (54))* X Inventory Database...CF04F9Q\kaitl (61))* /*create a stored procedure*/ Eluse Inventory; select from REP; select from CUSTOMER; select from ITEM; select from ORDERS; select from ORDER_LINE; /*In the existing query window, create a stored procedure to view the order details given order number*/ /*In the existing query window, create a stored procedure to insert a new order to ORDERS table*/ Fcreate procedure insert_new_order @varl char(5), @var2 date, @var3 char (3) as begin insert into ORDERS values (@var1,@var2,@var3); print 'New order added to the ORDERS table'; end [exec insert_new_order '51700', '11/15/2022', '126; SQLQuery3.sql - LA...CF04F9QV