Discussion:
Q1. 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.
Q2. 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.