/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 votes229 views3 answers
Mysql auto increment after delete
SQL
12 votes285 views4 answers
How to drop all tables in postgresql
SQL
0 vote225 views1 answer
Redshift running queries
SQL
0 vote371 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL
24 votes210 views5 answers
Import dump mysql
SQL
0 vote231 views1 answer
Remove mysql from centos 7
SQL
0 vote200 views1 answer
Show table details postgresql
SQL
11 votes210 views2 answers
Oracle saurce code
SQL
-2 votes200 views1 answer
Remove root password mysql
SQL
0 vote200 views1 answer
T-sql check if data exists
SQL