Stored procedures in SQL 2008 can be written in a variety of languages.
• Why do you think that it would be important to have the flexibility of using a variety of languages in the development of database systems?
• How would you use a stored procedure?
• Provide an example of a stored procedure that you might write to demonstrate why this capability is important.
• Would you ever want to use a temporary stored procedure? Why or why not?
• What are some differences in coding when creating a stored procedure in SQL Server vs. Oracle?
The responses to these questions can be in short paragraphs as it is for a discussion board. Please provide references in APA style if needed. Let me know if you have any questions.