/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

0 vote209 views1 answer
Oracle character index
SQL
13 votes360 views4 answers
Sql joining 3 tables
SQL
0 vote232 views1 answer
Mysql bind-address default value
SQL
0 vote188 views2 answers
Influxdb delete measurement based on date
SQL
-1 vote219 views1 answer
Add column alter table default value
SQL
0 vote218 views1 answer
Sql recherche nom prenom
SQL
0 vote229 views1 answer
Prodection ready postgres database step by step
SQL
13 votes213 views4 answers
Mysql get last row
SQL
2 votes213 views1 answer
SQL column name Postgre
SQL
-1 vote214 views1 answer
Io
SQL