When to use temp table? Sushant Mishra127418-Sep-2017databasesql server sql sql server 2012 Updated on 22-Sep-2020
Sushant Mishra
18-Sep-2017We 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.