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 Server – Local temporary table
Local temporary table:- Local temporary table is created in the tempdb and it is visible to the current user’s session…
SQL Server – Global temporary tables
Global temporary table:- Global temporary table is created in the tempdb and it is visible to all other sessions as…