/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 vote176 views3 answers
Osx stop mysql service
SQL
0 vote121 views1 answer
Mysql order by where condition sub query
SQL
0 vote116 views2 answers
Sql trigger difference between for and after
SQL
0 vote133 views2 answers
Nested query
SQL
0 vote106 views1 answer
Sql string contains case sensitive
SQL
0 vote111 views1 answer
Display first three characters sql
SQL
3 votes110 views2 answers
Funktion LOWER/UPPER sql
SQL
0 vote119 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
1 vote110 views1 answer
Psql human readable
SQL
19 votes112 views3 answers
How to change column type psql
SQL