/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 vote362 views1 answer
Permission denied postgres \copy csv command line
SQL
1 vote394 views1 answer
Ora-01109 database not open in oracle 19c
SQL
5 votes318 views2 answers
Create table
SQL
1 vote379 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
0 vote362 views1 answer
Sql where part of string match
SQL
0 vote392 views3 answers
Mysql keyword search
SQL
0 vote351 views1 answer
Postgresql default value boolean
SQL
4 votes366 views3 answers
Rename table column postgresql
SQL
0 vote366 views1 answer
How to run mysql in git bash
SQL
3 votes357 views2 answers
Oracle sql select all days between two dates except weekends
SQL