/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 vote108 views2 answers
Disallowed function mysql to_date()
SQL
1 vote98 views1 answer
Store select query result in variable sql server
SQL
1 vote107 views1 answer
How to fetch alternate records from two tables
SQL
0 vote106 views1 answer
MySQL INSERT IGNORE Statement
SQL
0 vote60 views1 answer
Select all domains of database firbird
SQL
0 vote105 views1 answer
View to table
SQL
0 vote110 views1 answer
Oracle concat datetime
SQL
0 vote99 views1 answer
I wanted to select among the rows the highest value in mysql
SQL
1 vote148 views1 answer
Sql comment header
SQL
1 vote104 views1 answer
Get table which have specific columns in mysql
SQL