/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 vote144 views1 answer
Sql server sleep
SQL
0 vote135 views1 answer
Connect by query in oracle
SQL
2 votes163 views1 answer
Mysql now format
SQL
10 votes135 views4 answers
Mysql one week ago
SQL
0 vote219 views1 answer
Mysql select field if condition
SQL
1 vote131 views1 answer
ERROR 1193 (HY000): Unknown system variable 'GTID_PURGED'
SQL
0 vote157 views1 answer
Php insert null mysql
SQL
1 vote131 views1 answer
Mysql view curren querys
SQL
0 vote133 views1 answer
Create relationship with betwen two tables in postgersql
SQL
6 votes1.2K views1 answer
Sql select second max
SQL