/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 vote252 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
7 votes267 views2 answers
What is sql clause
SQL
1 vote274 views1 answer
Oracle check table lock
SQL
0 vote297 views1 answer
How to check rollback status in oracle
SQL
0 vote265 views1 answer
<sql:datasource var="Snapsho"
SQL
5 votes217 views1 answer
Alter table default value mysql
SQL
0 vote277 views1 answer
How to find total working hour in sql
SQL
3 votes240 views1 answer
Oracle nextval
SQL
19 votes263 views5 answers
Date between in mysql
SQL
6 votes240 views1 answer
Sqlite foreign key
SQL