TABLE Variable | TEMP Table vs TABLE Variable | TABLE Variable vs Table-Valued Type

TABLE Variable | TEMP Table vs TABLE Variable | TABLE Variable vs Table-Valued Type Agenda: ------------- Q01. What is Table Variable in SQL? Q02. In which version of SQL the Table Variable was introduced? Q03. Can you create a Table variable schema by using the SELECT INTO command? Q04. Can you use the User Defined Type in the Table Variable? Q05. Can you assign a table variable to other table variables in SQL? Q06. What is the storage location of a table variable? Q07. Can you access the Table Variable before declaring it? Q08. What is the scope of the Table Variable in SQL? Q09. Can you use a Table Variable in Dynamic Query? Q10. Can you ALTER the Table Variable? Q11. Can you create an Index and constraints in Table Variable? Q12. Can you add Foreign Key Constraints in Table Variable? Q13. Can you Create an IDENTITY Column in Table Variable? Can you insert IDENTITY Values in the Table variable explicitly? Q14. Can you create Clustered Index on Table V