34 Contributors: 2 Friday, December 23, 2016
Licensed under: CC-BY-SA
Not affiliated with Stack Overflow
Rip Tutorial:
Roadmap: roadmap

Use of TEMP Table


Temporary Tables are really very helpful.

The table can be created at runtime and can do all operations which are done in a normal table.

These tables are created in a tempdb database.

Used when ?

  1. We have to do complex join operation.

  2. We do large number of row manipulation in stored procedures.

  3. Can replace the usage of cursor.

Thus increases the performance.

Related Examples