/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 vote113 views1 answer
Java mysql date format
SQL
0 vote112 views1 answer
Oracle dynamic select into
SQL
0 vote135 views2 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'world.admin_tasks' doesn't exist
SQL
0 vote136 views1 answer
MySQL get all previous date record
SQL
1 vote136 views2 answers
Remove space in mysql
SQL
0 vote133 views1 answer
Load data infile mariadb slow
SQL
2 votes125 views1 answer
Mysql change data type of column
SQL
13 votes125 views1 answer
Sql join 3 tables on id
SQL
0 vote121 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
0 vote75 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL