/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

2 votes268 views2 answers
Mysql date range
SQL
0 vote264 views1 answer
Change default schema sql server
SQL
2 votes289 views1 answer
Creating a view SQL
SQL
0 vote285 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
1 vote262 views2 answers
Sql where is not number
SQL
0 vote291 views2 answers
Greater than sql server
SQL
2 votes285 views1 answer
Oracle kill session by sql_id
SQL
0 vote308 views1 answer
SQL joins in python
SQL
1 vote275 views1 answer
Query for all indexes in table postgres
SQL
0 vote305 views1 answer
What logs are available on RDS MySQL?
SQL