/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 vote153 views1 answer
How to see the content of tables in pgadmin
SQL
0 vote225 views1 answer
Login failed for user sql server
SQL
0 vote205 views1 answer
Oracle service name view
SQL
0 vote213 views1 answer
Plsql find location of procedure
SQL
1 vote202 views1 answer
Apex ORA-20999
SQL
1 vote194 views1 answer
Oracle list datafiles in tablespace
SQL
0 vote260 views2 answers
Suse stop MySQL
SQL
1 vote231 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
0 vote214 views1 answer
Check if has alpha characters sql
SQL
22 votes275 views4 answers
Date format mysql
SQL