/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 vote154 views1 answer
Sql pivot without aggregate
SQL
3 votes152 views3 answers
Mysqldump: couldn
SQL
2 votes153 views1 answer
Sql column values comma separated
SQL
0 vote197 views1 answer
Sqlite trim
SQL
1 vote156 views1 answer
Alter add syntax
SQL
1 vote169 views2 answers
Mysql trim spaces
SQL
2 votes176 views1 answer
Revokeprivileges mysql
SQL
13 votes167 views5 answers
Sql default
SQL
1 vote166 views1 answer
Show structure of table in sql
SQL
2 votes166 views2 answers
Change mysql password from command line
SQL