Select from following answers:
Show Correct Answer
- It starts with single hash value "#" as the prefix of the table name.
- A Local Temporary Table is only for the connection in which it was created.
- 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.".
- If the Temporary Table is created in a Stored Procedure then it is automatically dropped on the completion of the Stored Procedure execution.
- All Above
Asked In: Many Interviews |