/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

4 votes110 views2 answers
Select todays data postgres query
SQL
2 votes156 views4 answers
2nd highest salary in mysql
SQL
18 votes142 views2 answers
Sql inner join
SQL
4 votes151 views2 answers
Sqlalchemy_database_uri for mysql
SQL
1 vote178 views3 answers
How to update column name in psql
SQL
11 votes145 views2 answers
Having in sql
SQL
0 vote138 views1 answer
Sequelize postgresql schema
SQL
0 vote135 views1 answer
Set column width in sqlplus
SQL
5 votes169 views3 answers
Db begintransaction laravel
SQL
3 votes174 views2 answers
Find string in stored procedure sql server
SQL