Create a Stored Procedure: Stored procedures allow you to make changes to the database structure and...

Transcribed Image Text:

Create a Stored Procedure: Stored procedures allow you to make changes to the database structure and manage performance without needing to rewrite applications or deploy application updates. In this exercise, you create two stored procedures to compare the processing efficiency of a set- oriented routine and a cursor-based routine. 1. In the query window, create and execute a cursor-based stored procedure - to display the item details for the given category 2. In the existing query window, create a stored procedure to view the order details given order number 3. In the existing query window, create a stored procedure to insert a new order to ORDERS table /*create a stored procedure*/ Euse 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*/ Ecreate procedure insert_new_order @var1 char(5) @var2 date, @var3 char(3) as begin B% insert into ORDERS values(@var1,@var2,@var3); print 'New order added to the ORDERS table'; end [exec insert_new_order '51700 ,'11/15/2822', '126; Messages (1 zo affected) New order added to the ORDERS table Completion time: 2022-11-22T21:14:59.1633205-05:00 Create a Stored Procedure: Stored procedures allow you to make changes to the database structure and manage performance without needing to rewrite applications or deploy application updates. In this exercise, you create two stored procedures to compare the processing efficiency of a set- oriented routine and a cursor-based routine. 1. In the query window, create and execute a cursor-based stored procedure - to display the item details for the given category 2. In the existing query window, create a stored procedure to view the order details given order number 3. In the existing query window, create a stored procedure to insert a new order to ORDERS table /*create a stored procedure*/ Euse 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*/ Ecreate procedure insert_new_order @var1 char(5) @var2 date, @var3 char(3) as begin B% insert into ORDERS values(@var1,@var2,@var3); print 'New order added to the ORDERS table'; end [exec insert_new_order '51700 ,'11/15/2822', '126; Messages (1 zo affected) New order added to the ORDERS table Completion time: 2022-11-22T21:14:59.1633205-05:00