/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 votes140 views1 answer
Get column name sql server
SQL
0 vote129 views1 answer
Sql change primary key to composite key
SQL
3 votes158 views5 answers
Duplicate table sql
SQL
5 votes160 views3 answers
Db begintransaction laravel
SQL
10 votes137 views5 answers
Between keyword in sql
SQL
1 vote137 views1 answer
How to check the mysql version mac
SQL
-1 vote133 views1 answer
Condition in orderby mysql
SQL
7 votes143 views3 answers
Convert ansi sql
SQL
0 vote128 views1 answer
Sql server whoami
SQL
0 vote125 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL