/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 vote291 views1 answer
Sql alchemy escape ; in insert statement
SQL
0 vote276 views1 answer
Mysql bind-address default value
SQL
0 vote249 views1 answer
What are the aggregate function in sql
SQL
1 vote285 views2 answers
Sql insert timestamp
SQL
38 votes359 views6 answers
Ubuntu install mysql client
SQL
12 votes257 views1 answer
Env var for setting password for root user mysql docker hub
SQL
4 votes252 views1 answer
SQL order random
SQL
5 votes238 views1 answer
Postgres upsert
SQL
4 votes267 views2 answers
Postgresql default value
SQL
0 vote306 views1 answer
Sql create and grant user access to database
SQL