Results 1 to 2 of 2
  1. #1
    Member
    Join Date
    Nov 2017
    Location
    India
    Posts
    36

    Thumbs up Compare Table Variables with Temporary Tables in Database?

    Found many mini and major articles online comparing Tables variables with Temporary Tables in MySQL. Most of them are very complex with huge list of content like scope, usage, creation, table name, column data types, collation, indexes, constraints, post creation DDL, data insertion, Insert explicit values into identity columns (SET IDENTITY_INSERT), Truncate table, destruction, Stored procedure recompilations, transactions, rollbacks, statistics, Pass to stored procedures, dynamic sql and Explicitly named objects (indexes, constraints). Can you explain any one of this in lucid manner with a real example?

  2. #2
    Registered User
    Join Date
    Dec 2018
    Posts
    40
    Temp Tables are physically created in the Tempdb database. These tables act as the normal table and also can have constraints, index like normal tables. CTE is a named temporary result set which is used to manipulate the complex sub-queries data.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

  Find Web Hosting      
  Shared Web Hosting UNIX & Linux Web Hosting Windows Web Hosting Adult Web Hosting
  ASP ASP.NET Web Hosting Reseller Web Hosting VPS Web Hosting Managed Web Hosting
  Cloud Web Hosting Dedicated Server E-commerce Web Hosting Cheap Web Hosting


Premium Partners:


Visit forums.thewebhostbiz.com: to discuss the web hosting business, buy and sell websites and domain names, and discuss current web hosting tools and software.