/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

5 votes220 views3 answers
Sql limit offset
SQL
0 vote172 views1 answer
Online sql testing tool
SQL
0 vote166 views1 answer
Describe in sqlite3
SQL
13 votes153 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
1 vote178 views2 answers
Sql example query
SQL
10 votes159 views2 answers
Mysql select timestamp group by day
SQL
0 vote179 views1 answer
Mysql isshow
SQL
0 vote178 views1 answer
Mysql max number not returning correct value
SQL
0 vote190 views1 answer
Oracle swap partition
SQL
1 vote171 views1 answer
Import database from a file using mysql commandline
SQL