/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 vote289 views8 answers
Sql to c# linq converter online
SQL
6 votes196 views1 answer
Phpmyadmin password root
SQL
9 votes218 views3 answers
Import DB through mysql console
SQL
1 vote206 views2 answers
Oracle list service names
SQL
0 vote203 views3 answers
ChAnge TABLE name apex oracle
SQL
28 votes163 views6 answers
Distinct sql
SQL
14 votes215 views3 answers
Trim sql
SQL
1 vote203 views3 answers
Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails
SQL
0 vote279 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
0 vote249 views1 answer
Selecting Multiple Columns in SQL
SQL