/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

23 votes266 views4 answers
How to uninstall postgresql in ubuntu
SQL
5 votes259 views2 answers
Sql server check port number
SQL
0 vote351 views1 answer
Mysql show schema
SQL
0 vote256 views1 answer
AddEntityFrameworkSqlite
SQL
6 votes254 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
0 vote228 views1 answer
Delete all rows from table sqlite
SQL
6 votes266 views1 answer
Postgresql add enum value
SQL
2 votes260 views1 answer
Mysql how to store lat,lng
SQL
4 votes265 views2 answers
Oracle sql group by date year
SQL
3 votes296 views2 answers
Oracle sql first day of month
SQL