WHEN TO USE TEMP TABLE?

Sushant Mishra

Total Post:37

Points:185
Posted by  Sushant Mishra
 146  View(s)
Ratings:
Rate this:
  1. Sushant Mishra

    Post:37

    Points:185
    When to use temp table?

    We can use temp table when we are doing large number of row manipulation in stored procedures.

    Temp table can be when we want to replace the cursor we can store the result set data into a temp table then we can manipulate the data from there.

    We can use temp table when we are having a complex join operation.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!