SQL Server - Difference between Local temporary table and Global temporary table .

The below are the few crucial differences between local and global temporary tables .

S.No	Local temporary table	Global temporary table
1	Denoted by # symbol.	Denoted by ## symbol.
2	Valid for the current connection only. and cleared as soon as the current connection closes	Available to all the connections once created. and cleared when the last connection is closed.
3.	Cannot be shared between multiple users.	Can be shared between multiple users.