/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 votes145 views1 answer
Sql query to make a existing column auto increment
SQL
4 votes144 views2 answers
Sql vs mysql
SQL
0 vote152 views1 answer
Rename constraint postgresql
SQL
2 votes157 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote151 views1 answer
Php mysqli install
SQL
0 vote191 views1 answer
Oracle plsql sleep
SQL
0 vote137 views1 answer
Sqlite to csv statement
SQL
3 votes191 views3 answers
Restart mysql mac
SQL
0 vote148 views1 answer
Windows services sql
SQL
0 vote152 views1 answer
Resullt all update knex mysql
SQL