SQL SERVER INTERVIEW QUESTIONS AND ANSWERS SQL SERVER

SQL SERVER INTERVIEW QUESTIONS AND ANSWERS

SQL SERVER INTERVIEW QUESTIONS AND ANSWERS PART 1 -WHAT ARE THE DIFFERENCES BETWEEN TABLE VARIABLES AND TEMPORARY TABLES VISIT US-sqlservertechandsas@gmail. com

SQL SERVER INTERVIEW QUESTIONS AND ANSWERS Table Variables Temporary Tables SYNTAX Table variables are not support DDL statements. like –Alter, Create, Drop. you can’t change the structure of table variables. Temp Tables are support DDL statements. like –Alter, Create, Drop. So you can change the structure of temp table after it’s created. STORAGE Table variables are stored in Temp. DB. (It available only batch of executions. ) (Select * from Tempdb. sys. tables) Temp Tables are also stored in Temp. DB. (It available either session are closed or dropped. ) TRANSACTIONS Table Variables can’t participate in explicit transactions. Temp Table can participate in explicit transactions. VISIT US-sqlservertechandsas@gmail. com

SQL SERVER INTERVIEW QUESTIONS AND ANSWERS Table Variables Temporary Tables USER DEFINED FUNCTIONS User Defined functions are allowed table variables on it. User Defined functions are not allowed temp tables on it. (it will throw an error ) INDEXES You can’t add indexes to a table variables explicitly. You can add indexes to a temp tables both implicit and explicit. SCOPE Scope of table variable is the batch or SP in which it’s declared. Scope of temp tables are depend what type of temp table has created. eg-Local or Global VISIT US-sqlservertechandsas@gmail. com

SQL SERVER INTERVIEW QUESTIONS AND ANSWERS !!!!THANKS YOU !!! PLESE SUBSCRIE AND LIKE OUR CHANEL FOR MORE VIDEOS VISIT US-sqlservertechandsas@gmail. com