Which statements are true concerning Local Temporary Tables?

 Posted by vishalneeraj-24503 on 10/8/2014 | Category: Sql Server Interview questions | Views: 1488 | Points: 40
Select from following answers:
  1. It starts with single hash value "#" as the prefix of the table name.
  2. A Local Temporary Table is only for the connection in which it was created.
  3. A Local Temporary Table is automatically dropped when the existing connection is closed, or the user can explicitly drop it with the following command "drop table #local_table.".
  4. If the Temporary Table is created in a Stored Procedure then it is automatically dropped on the completion of the Stored Procedure execution.
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response