A temporary table in SQL Server, as the name suggests, is a database table that exists temporarily on the database server. A temporary table stores a subset of data from a normal table for a certain period of time.
Temporary tables are particularly useful when you have a large number of records in a table and you repeatedly need to interact with a small subset of those records. In such cases instead of filtering the data again and again to fetch the subset, you can filter the data once and store it in a temporary table.
You can then execute your queries on that temporary table. Temporary tables are stored inside “tempdb” which is a system database.
Let’s take a look at how you can use a temporary data in a simple scenario.