Search for question
Question

5. Create a reusable stored procedure named "add_post" that uses parameters and allows you to insert any new post into the Post table. Instead of passing in the summary as

a parameter, derive the summary from the content, storing the derivation temporarily in a variable (which is then used as part of the insert statement). Recall that the summary field stores the first 12 characters of th econtent followed by “...". Execute the stored procedure to add a post of your choosing, then list out the Post table to show that the addition succeeded.

Fig: 1