What is the difference between a Local temporary table and a Global temporary table? How is each one denoted?
Local temporary table will be accessible to only current user session, its name will be preceded with a single hash (#mytable) Global temporary table will be accessible to all users, & it will be dropped only after ending of all active connections, its name will be preceded with double hash (##mytable)
