/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 votes349 views1 answer
How to find constraints on a table in oracle
SQL
0 vote295 views1 answer
FindAllBy
SQL
1 vote326 views2 answers
Sql multiline comment
SQL
6 votes342 views2 answers
Clear a table in mysql
SQL
1 vote328 views1 answer
How to give access to database in postgresql server to another user
SQL
0 vote329 views1 answer
Mysql docker image for macbook m1
SQL
0 vote335 views1 answer
Postgresql where clause not working
SQL
1 vote346 views1 answer
Sql where last 12 months
SQL
21 votes376 views6 answers
Update sql
SQL
2 votes394 views1 answer
Pdo mysql insert
SQL