/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

8 votes117 views2 answers
How to fetch data from database without last column
SQL
4 votes109 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
1 vote113 views1 answer
Operator does not exist: integer = text
SQL
5 votes126 views2 answers
Postgresql insert select
SQL
0 vote113 views1 answer
Events not working db
SQL
0 vote117 views1 answer
Mysql sql select one day before
SQL
1 vote79 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
-2 votes142 views3 answers
How to fetch first 10 rows in sql
SQL
0 vote112 views1 answer
Mysql count by month
SQL
0 vote123 views1 answer
Get last three characters in mysql column
SQL