/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

0 vote207 views2 answers
Amazon linux postgresql client
SQL
0 vote190 views1 answer
Alter table myisam to innodb
SQL
0 vote184 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
3 votes214 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
0 vote201 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
3 votes190 views3 answers
Update join
SQL
0 vote228 views1 answer
Postgresql on conflict pair
SQL
3 votes198 views3 answers
C# sql select
SQL
1 vote182 views2 answers
Mysql type conversion
SQL
0 vote194 views1 answer
Connecting to my cloud sql server with c#
SQL