/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 vote339 views1 answer
Version and edition of SQL Server Database Engine
SQL
0 vote351 views1 answer
How to use query in nosql
SQL
0 vote368 views1 answer
SQL Server rename foreign key constraint
SQL
0 vote363 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
0 vote376 views1 answer
How to Remove milliseconds from Date time
SQL
-1 vote371 views5 answers
Online sql to linq generator
SQL
0 vote333 views1 answer
Oracle sql date summer time
SQL
28 votes421 views6 answers
Sql update
SQL
0 vote371 views1 answer
Mysql check if lowercase
SQL
0 vote366 views1 answer
Sintaxis SELECT sql
SQL