TABLE Variable, TEMP Table vs TABLE Variable, TABLE Variable vs Table Valued Type

TABLE Variable, TEMP Table vs TABLE Variable, TABLE Variable vs TableValued 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