Chetana Barot
Difference between table variable and temporary tables
By Chetana Barot in SQL Server on Aug 28 2017
  • Manish Kumar
    Nov, 2017 17

    There is not so much difference between table variable and temp table. Both are using for capturing data temporary .Both are getting stored in tempdb.On Temp table we can have multiple index but in table variable we can have only one index which depends on primary key.Global temp table (type of temp table) can be accessed by multiple session but table variable is for current scope only.

    • 0

Most Popular Job Functions