1 Answers

Sushant Mishra
Sushant Mishra

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