/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

2 votes163 views1 answer
Oracle table size
SQL
0 vote165 views1 answer
Transalations from sql to Linq count and group by
SQL
1 vote171 views1 answer
Sql server today minus n
SQL
6 votes167 views1 answer
Allsource oracle
SQL
16 votes187 views5 answers
Select last row in sql
SQL
5 votes174 views2 answers
Oracle list columns schema
SQL
0 vote171 views1 answer
Mysql set boolean default value
SQL
9 votes180 views4 answers
SQL Date Format
SQL
0 vote213 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
11 votes178 views1 answer
Mysql order by two columns priority
SQL