Pradip Pandey
What is the difference between table variable and a temporary table in sql.
By Pradip Pandey in ASP.NET on Apr 04 2013
  • Shekhar Panwar
    Nov, 2016 3

    The temporary tables are stored in tempdb database of SQL server. The Table Variables are stored in both the memory and the disk in the tempdb database. The structure of Temporary Tables can be created even after its creation. ... In the example we have created a Temporary Table named as Employee.

    • 0
  • kannan thangamoney
    Feb, 2014 18

    Temporary Tables: 1)Not Pre-compiled 2)Transaction log recorded 3)Scope - session Table Variables: 1)Pre-compiled 2)Transaction log NOT recorded 3)Scope - variable

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS