Looking for sql-server Answers? Try Ask4KnowledgeBase
Looking for sql-server Keywords? Try Ask4Keywords

Microsoft SQL ServerUse 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.