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

  Discussion forum


Leave an answer