Write a script that creates and calls a stored procedure named spInsertCategory. First, code a statement that
Fantastic news! We've Found the answer you've been seeking!
Question:
- Write a script that creates and calls a stored procedure named spInsertCategory. First, code a statement that creates a procedure that adds a new row to the Categories table. To do that, this procedure should have one parameter for the category name.
Code at least two EXEC statements that test this procedure. (Note that this table doesn't allow duplicate category names.)
Related Book For
Concepts of Database Management
ISBN: 978-111182591
7th edition
Authors: Philip J. Pratt, Joseph J. Adamski
Posted Date: