You plan to design an application that temporarily stores data in a SQL Azure database.
You need to identify which types of database objects can be used to store data for the
application. The solution must ensure that the application can make changes to the schema
of a temporary object during a session.
Which type of objects should you identify?
A.
Common table expressions (CTEs)
B.
Temporary stored procedures
C.
Temporary tables
D.
Table variables
Explanation:
http://msdn.microsoft.com/en-us/library/ms175972.aspx
http://msdn.microsoft.com/en-us/library/ms189084.aspx
http://msdn.microsoft.com/en-us/library/ms175010.aspx
http://msdn.microsoft.com/en-us/library/bb510489.aspx
http://msdn.microsoft.com/en-us/library/ms187926.aspx
http://zacksfiasco.com/post/2010/01/21/SQL-Server-Temporary-Stored-Procedures.aspx