1. Stored procedures in SQL 2005 can be written in a variety of languages. Why is this important in the development of database
systems? Provide an example of a stored procedure that a database designer might write to demonstrate why this capability is
important. Please include references.
2. Which is better to use, a sub query or a join? Why? Please include example of each to support your reasoning. Also, please
include references.