t USE an EXISTING schema for the YELP Use If and Else condition in 2 of...

 

Transcribed Image Text:

t USE an EXISTING schema for the YELP Use If and Else condition in 2 of 3 Stored Procedures - Create a stored procedure that allows you to add data to your table - Call the procedure and pass up to 5 different rows of values - Create a stored procedure to update those values in 1 of 3 tables - Call the procedure and pass up to 3 different rows of values to be modified - Create a stored procedure to perform both a soft/hard delete - Call the procedure to use on 2 rows Save all 3 Stored Procedures as: sp_Update+Name.sql, sp_Add+Name.sql and sp_Purge+Name.sql Provide all .SQL Files Provide a PDF with screenshot showing the Procedures were called and the data results Posted Mon Aug 22, 2022 at 4:11 pm Comments 02 t USE an EXISTING schema for the YELP Use If and Else condition in 2 of 3 Stored Procedures - Create a stored procedure that allows you to add data to your table - Call the procedure and pass up to 5 different rows of values - Create a stored procedure to update those values in 1 of 3 tables - Call the procedure and pass up to 3 different rows of values to be modified - Create a stored procedure to perform both a soft/hard delete - Call the procedure to use on 2 rows Save all 3 Stored Procedures as: sp_Update+Name.sql, sp_Add+Name.sql and sp_Purge+Name.sql Provide all .SQL Files Provide a PDF with screenshot showing the Procedures were called and the data results Posted Mon Aug 22, 2022 at 4:11 pm Comments 02