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?