/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 vote316 views1 answer
Sql convert datetime to year
SQL
0 vote337 views1 answer
Count columns psql(PostreSQL)
SQL
0 vote312 views1 answer
Opensuse stop MySQL
SQL
37 votes401 views6 answers
Mysql update
SQL
2 votes293 views2 answers
Mysql all columns
SQL
3 votes319 views1 answer
MySQL DELETE JOIN
SQL
0 vote310 views1 answer
Mysql find db contarint
SQL
0 vote313 views1 answer
Reset keys in sql
SQL
5 votes332 views5 answers
Sqlite install python
SQL
6 votes338 views2 answers
Difference between join vs union
SQL