| S.No | Particulars | Local Temp Table | Global Temp Table |
|---|---|---|---|
| 1 | Available | SQL Server session or connection (means single user) | all SQL Server sessions or connections (means all the user). |
| 2 | deleted | These are automatically deleted when the session that created the tables has been closed | These can be created by any SQL Server connection user and these are automatically deleted when all the SQL Server connections have been closed. |
| 3 | stared with sign | Local temporary table name is stared with single hash ("#") sign. | Global temporary table name is stared with double hash ("##") sign. |
Share Dot Net Experience