Temporary Tables: The scope of Local temporary tables is in the current session and Global temporary tables is till the connection exists. Can Truncate Temporary tables Can be part of a Transaction We pre-fix the table name with #(Local) or ##(Global) Can

Read More