Question 12


Answer C is correct. If you are going to create a process in which a new table is going to be generated on every execution, you need to use SELECT INTO to generate a table and a variable to hold the name of the table. INSERT (INTO) assumes that the table has already been created. # and ## are used for temporary tables.

For more information, see the following sources:

  • Chapter 2, "Creating Database Objects"

  • SQL Server 2005 Books Online: "SQL Server Database Engine, Accessing and Changing Database Data, Changing Data in a Database, Inserting Data into a Table, Adding Rows by Using INSERT and SELECT INTO, Inserting Rows by Using SELECT INTO"




MCTS 70-431(c) Implementing and Maintaining Microsoft SQL Server 2005
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Thomas Moore

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net