/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

21 votes323 views3 answers
Average sql
SQL
0 vote347 views1 answer
Flush user resource mysql
SQL
0 vote337 views1 answer
Mysql DDL
SQL
8 votes349 views1 answer
Oracle search text in all packages
SQL
6 votes330 views5 answers
Alter table oracle
SQL
0 vote354 views2 answers
Create row number in sql
SQL
6 votes355 views2 answers
Postgresql database url
SQL
3 votes337 views3 answers
Start postgresql ubuntu
SQL
0 vote350 views1 answer
How to remove quotes from a string in ssis load file
SQL
12 votes326 views2 answers
Delete entries in postgresql
SQL