/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

5 votes134 views2 answers
Copy data from one database to another
SQL
2 votes147 views1 answer
How to show the whole table in sql
SQL
0 vote138 views1 answer
Postgres 11 add primary key
SQL
0 vote129 views1 answer
Psql check if value in array
SQL
0 vote153 views1 answer
Oracle execute immediate quotes
SQL
8 votes143 views2 answers
Safe update mode in mysql
SQL
0 vote138 views1 answer
Mysql xampp reset root password
SQL
0 vote136 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
0 vote184 views1 answer
Sql server is not
SQL
0 vote133 views1 answer
Postgres : ERROR: division by zero
SQL