Local Temporary tables Visible only to the current session. Multiple users can’t use the same table. To create these, table name should be prefixed with ‘#’                 Ex: CREATE TABLE dbo.#LocalTemp….. Dropped automatically when the current session is closed  Global Temporary tables Visible

Read More