SQL Server Transact Basic to Expert - Query a temporary and a table variable tables

SQL Server Transact Basic to Expert - Query a temporary and a table variable tables

This blog shows how to query data in the temporary table and the table variable tables:

Example:

Select * from #empsalary  (Temporary Table)

Select * from @empsalary  (Table Variable)