UAESol

Web hosting Support

Hosted by UAESol

Any question about the dedicated hosing servers, VPS servers, shared web hosting and ccTLD can be asked here. Discus your hosting related problems and have a perfect solution here.

  • 609
    MEMBERS
  • 4362
    MESSAGES
  • 0
    POSTS TODAY

Discussions

what are temporary tables in SQL Server?

Started Feb-19 by kannaa; 33 views.
In reply toRe: msg 1
afikl

From: afikl

Feb-24

A temporary table is a database object that is stored and managed by the database system on a temporary basis. Temporary tables can be local or global. Local temporary tables are physically represented, i.e. they are stored in the tempdb system database. Temporary table names start with a # prefix, for example #table_name. Learn more in the article create temp table sql . Separately, I want to note that the temporary table belongs to the session that created it, and is visible only to this session. The temporary table is dropped when the session that created it ends.

TOP