/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

3 votes315 views3 answers
Restart mysql mac
SQL
1 vote319 views1 answer
Postgres set sequence value to max id
SQL
25 votes332 views6 answers
Import database mysql command line
SQL
0 vote264 views0 answer
SQL
6 votes303 views1 answer
Phpmyadmin password root
SQL
0 vote288 views2 answers
Mysql get routine parameter list
SQL
2 votes305 views3 answers
How to pass password mysql command line
SQL
0 vote330 views1 answer
Sql query wordpress export post
SQL
0 vote325 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
0 vote317 views1 answer
Sql remove decimal places
SQL