/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 vote169 views1 answer
Get the previous column of a table in mysql
SQL
0 vote159 views1 answer
Mssql current date
SQL
1 vote218 views1 answer
Postgresql where datetrunc month and year equal
SQL
0 vote186 views1 answer
How to see the query of a view in mysql
SQL
0 vote175 views1 answer
Print orcale
SQL
15 votes153 views7 answers
MYSQL
SQL
4 votes169 views1 answer
Mysql not equal
SQL
0 vote161 views1 answer
Add timestamp column to existing table ms sql server
SQL
0 vote166 views1 answer
Events not working db
SQL
3 votes160 views1 answer
Sql multiple column index
SQL