Exit 70-464 Developing Microsoft SQL Server Databases
Question 1 of 5
0% complete
Q1 Single choice

You plan to modify a stored procedure to use temporary data.

The stored procedure must meet the following requirements:

1. Favor physical memory when physical memory is available.
2. Be able to roll back changes to the temporary data.

You need to recommend which object to add to the stored procedure.

Which Transact-SQL command should you recommend?

  • A

    CREATE TABLE ##Table...

  • B

    CREATE DEFAULT Table...

  • C

    CREATE VIEW Table...

  • D

    DECLARE TABLE @ Table...

Previous Next