/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 vote184 views1 answer
Mariadb get column names from table
SQL
0 vote258 views1 answer
Grant privileges mysql to database 1064
SQL
1 vote194 views2 answers
Oracle create synonym
SQL
1 vote170 views3 answers
Grant syntax in sql
SQL
0 vote201 views2 answers
How to check if sqlite table exists in nodejs
SQL
0 vote190 views1 answer
Oracle service name view
SQL
0 vote182 views1 answer
Mariadb current date plus 1 day
SQL
4 votes192 views3 answers
Sql drop primary key
SQL
2 votes213 views3 answers
How to get second highest salary in each department in sql
SQL
53 votes554 views6 answers
Sql server alter column
SQL