/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 vote219 views1 answer
Create index concurrently postgres
SQL
0 vote248 views1 answer
Mysql dump with table query
SQL
0 vote188 views1 answer
Sql truncate table referencing itself
SQL
0 vote226 views1 answer
Find most frequent value in SQL column
SQL
1 vote247 views1 answer
Trim leading zeros in sql
SQL
0 vote215 views1 answer
Sqldf change user
SQL
1 vote227 views1 answer
Sql server locks
SQL
10 votes228 views2 answers
Linux command line import mysql database
SQL
0 vote283 views1 answer
Reset a table's identity column and remove test records
SQL
0 vote227 views1 answer
Set engine to innodb
SQL