/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

3 votes237 views1 answer
Select table column in sql
SQL
4 votes302 views2 answers
Sql display today's date
SQL
0 vote227 views1 answer
Sql row number in result set
SQL
0 vote244 views1 answer
Remove transient options sql wordpress
SQL
11 votes235 views2 answers
Set default column value sql
SQL
1 vote249 views1 answer
Sql count value greater than
SQL
0 vote234 views1 answer
Pl sql round
SQL
0 vote388 views1 answer
Get first match in each group mysql query
SQL
1 vote222 views4 answers
Fatal database postgres does not exist
SQL
0 vote230 views1 answer
Replace null value within column mysql
SQL