SQL Server Table Variables - TEMP TABLES vs TABLE VARIABLES

Описание к видео SQL Server Table Variables - TEMP TABLES vs TABLE VARIABLES

https://www.udemy.com/sql-server-fast...
Discussion of Table Variables vs Temp Tables. Which should you use over the other and when? If one is always better then why do both types exist? Do both have distinct benefits in different situations? The answer is yes, they each have benefits. While TEMP TABLES need not be defined they can also be responsible for persistent artifacts in the TEMP DATABASE when you are doing complicated processing (loops, cursors, etc).

Комментарии

Информация по комментариям в разработке