15 July 2011

Difference between Temporary tables and Global Temporary Tables in Sql Server 2008

Difference between Temporary tables and Global Temporary Tables in Sql Server 2008

Temporary tables and Global Temporary tables in Sql Server 2008

-Temporary tables and Globale Temporary tables used to copy data to a sort of virtual table (or a records set) so that you can change the values with and not affect the actual data in the actual table. And then return the results of the virtual table
Difference between Temporary tables and Global Temporary Tables
-Global temporary tables are visible to all SQL Server connections but Temporary tables only accessed or used by particular user in the session .



No comments:

Post a Comment

Comments Welcome

Consistency level in Azure cosmos db

 Consistency level in Azure cosmos db Azure Cosmos DB offers five well-defined consistency levels to provide developers with the flexibility...