/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

1 vote135 views1 answer
Sql select whole row max column
SQL
0 vote140 views1 answer
Sql server current time without date
SQL
0 vote124 views1 answer
Print boolean in plsql
SQL
0 vote132 views1 answer
Select place default lat long
SQL
0 vote126 views1 answer
Pl sql round
SQL
0 vote130 views1 answer
Postgres sequence name
SQL
14 votes121 views2 answers
Oracle add column with default value
SQL
2 votes196 views1 answer
Mysql create user with remote access
SQL
0 vote131 views1 answer
How to connect to mysql in ef 6
SQL
0 vote131 views1 answer
How to select a row in sql
SQL