Search code examples
sql-servervirtual-table

Are table variables and virtual tables the same thing?

Are virtual tables and table variables the same in SQL Server? What is a virtual table? Why we need virtual tables, and how do you create one?

Solution

  • No, They aren't same.

    Go through this answer for clear understanding.

    https://dba.stackexchange.com/questions/16385/whats-the-difference-between-a-temp-table-and-table-variable-in-sql-server