/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

1 vote191 views1 answer
Find a column in all tables postgres
SQL
10 votes212 views6 answers
Sql between
SQL
0 vote196 views1 answer
Spark sql grows beyond 64 kb
SQL
0 vote186 views2 answers
Sql update top 100
SQL
11 votes212 views2 answers
Set default column value sql
SQL
0 vote172 views1 answer
Call scalar valued function sql
SQL
6 votes273 views2 answers
Non relational database
SQL
0 vote197 views1 answer
Amount of entries in a table psql
SQL
1 vote179 views2 answers
Oracle difference between two dates in seconds
SQL
1 vote334 views1 answer
Sql check roles
SQL