/SQL/Sql server: difference between hashtable and table declared using declare keyword

Sql server: difference between hashtable and table declared using declare keyword

There are quite differences like below.
1. Declarations: Table variables are declared as normal variables with type as table and columns along with their datatype.
whereas hashtables are created just like the normal tables.
Eg. i) Table Variable:  Declare @tmpTable as Table(id Int, Name Varchar(500), Salary Decimal)
	ii) Hashtable: Create Table(id Int, Name Varchar(500), Salary Decimal);

2. Next differences are where they are stored like Table variables are in Memory and Hashtables in tempdb.
3. As Hashtables are just like normal tables you can use them in transactions whereas not the table variables.
4. You can create indexes on Hashtables but not on table variables except the primary key indexes.
5. It's best to use table variables when you have small to moderate data to handle because of their better performance, as they reside in the memory.

Similar codes

1 vote324 views1 answer
Oracle sql listagg
SQL
0 vote270 views2 answers
Jupyter notebook connect to database
SQL
2 votes338 views2 answers
Install postgresql
SQL
0 vote350 views1 answer
Select sql in descending order
SQL
50 votes402 views6 answers
Install mysql on ubuntu
SQL
3 votes347 views1 answer
Create a table with an id in mysql
SQL
1 vote351 views2 answers
Procedure syntax
SQL
1 vote321 views2 answers
Oracle list partitioned tables
SQL
0 vote347 views1 answer
Oracle exchange subpartition
SQL
0 vote350 views1 answer
Openquery update linked server
SQL