IT Blog

  • Blog
  • Technology
    • Technology
    • Architecture
    • CMS
    • CRM
    • Web
    • DotNET
    • Python
    • Database
    • BI
    • Program Language
  • Users
    • Login
    • Register
    • Forgot Password?
  • ENEN
    • 中文中文
    • ENEN
Experience IT
In a World of Technology, People Make the Difference.
  1. Home
  2. Technology
  3. Database
  4. Temporary tables lifetime

Temporary tables lifetime

2017-11-03 789 Views 0 Like 0 Comments

There are two type of temporary tables in SQL Server: local and global temporary tables.

1. Local temporary #tables

If a database session creates the local temporary table #employees, only the session can work with the table, and it is deleted when the session disconnects.

2. global temporary ##tables

If no other user works with this table after you create it, the table is deleted when you disconnect.
If another user works with the table after you create it, SQL Server deletes it after you disconnect and after all other sessions are no longer actively using it.

ref

 1,742 total views,  4 views today

error
fb-share-icon
Tweet
fb-share-icon
IT Team
Author: IT Team

Tags: None
Last updated:2017-11-03

IT Team

This person is lazy and left nothing

Like
< Previous
Next >

Comments

Cancel reply
Chinese (Simplified) Chinese (Simplified) Chinese (Traditional) Chinese (Traditional) English English French French German German Japanese Japanese Korean Korean Russian Russian
Newest Hotspots Random
Newest Hotspots Random
All Unicode Chars How to keep and display contact form 7 data Common Regular Expressions How to block bad bots in Appache server Add ALT attribute to Social Media Icon Change Event Calendar Title
All Unicode Chars
Change Event Calendar Title JQuery get checkbox value SQL Server Transaction Exception Handling Best Practice Special characters and symbols for HTML Get horizontal data from "contact-form-7-to-database-extension" plugin Idempotency and Safety
Categories
  • Architecture
  • BI
  • C#
  • CSS
  • Database
  • DotNET
  • Hosting
  • HTML
  • JavaScript
  • PHP
  • Program Language
  • Python
  • Security
  • SEO
  • Technology
  • Web
  • Wordpress

COPYRIGHT © 2021 Hostlike IT Blog. All rights reserved.

This site is supported by Hostlike.com