/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 vote188 views1 answer
Postgres delete from where date is greater than specific date
SQL
4 votes174 views1 answer
Create db table
SQL
52 votes822 views6 answers
Rename column sql
SQL
5 votes179 views3 answers
Mysql extract month from date
SQL
2 votes266 views2 answers
Set value to null sql
SQL
0 vote172 views1 answer
Replace multiple string in query sql
SQL
6 votes308 views1 answer
Sql insert values into table
SQL
1 vote191 views1 answer
Select 2 rows in sql
SQL
0 vote181 views1 answer
Tsql cmd exec script from file
SQL
16 votes201 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL