SQL Server-Table Variable
Table variable:- SQL Server provides an variable known as table variable which is used to store data in a similar…
SQL Temporary Tables
Table variable:- SQL Server provides an variable known as table variable which is used to store data in a similar…
Local temporary table:- Local temporary table is created in the tempdb and it is visible to the current user’s session…
Global temporary table:- Global temporary table is created in the tempdb and it is visible to all other sessions as…