/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 vote140 views1 answer
Get clob size oracle
SQL
25 votes141 views5 answers
Date in mysql
SQL
14 votes147 views3 answers
How to add default constraint in mysql
SQL
0 vote137 views1 answer
Tsql default value when no value returned by query
SQL
2 votes142 views1 answer
Oracle table size
SQL
9 votes139 views3 answers
Oracle undo usage by session
SQL
1 vote171 views1 answer
Homebrew install mysql
SQL
1 vote137 views1 answer
Oracle select first result
SQL
6 votes151 views4 answers
Mysql group by month
SQL
0 vote149 views1 answer
Mysql insert into select with recursive
SQL