/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 votes177 views1 answer
Mysql change primary key
SQL
24 votes185 views2 answers
Alter table delete column
SQL
17 votes182 views6 answers
Mysql import sql file
SQL
1 vote205 views1 answer
Mysql size int
SQL
0 vote217 views3 answers
Mysql CAST(amount as float)
SQL
14 votes1.2K views1 answer
Sql value of string
SQL
4 votes181 views1 answer
Sql query to make a existing column auto increment
SQL
1 vote201 views1 answer
Insert value to new table by joining 2 different tables
SQL
0 vote183 views1 answer
Mysql repair a table
SQL
0 vote174 views1 answer
Learn sqlite dart
SQL