* Both are saved in tempDB
* Temp table can't be used in functions.
* Can't impose indexes on table variable.
http://dba.stackexchange.com/questions/16385/whats-the-difference-between-a-temp-table-and-table-variable-in-sql-server/16386#16386
* Temp table can't be used in functions.
* Can't impose indexes on table variable.
http://dba.stackexchange.com/questions/16385/whats-the-difference-between-a-temp-table-and-table-variable-in-sql-server/16386#16386
No comments:
Post a Comment