Temporary Tables in Sql Server
What is Temporary Tables Temporary Tables are very similar to the permanent tables. As the name suggests, a temporary table in SQL Server that exists temporarily on the database server.Temporary tables are stored inside "tempdb" system database. Types of Temporary Tables 1. Local Temporary Tables 2. Global Temporary Tables 1. Local Temporary Tables A 'Local Temporary Table' is available for only for the connection which is created the table. The same table will not be available for other connections. A 'Local Temporary Table' is dropped automatically once the connection which creates the table is closed. You can create 'Local Temporary Tables' with same table name but different connections. Each connections will create it's own version of temporary table. If stored Procedure creates a local temporary, it gets droped immediately after the completion of the execution of stored procedure. Local temporary table name is stared with ha