/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

-2 votes288 views1 answer
No module named '_sqlite3
SQL
9 votes265 views6 answers
Sql insert into
SQL
22 votes281 views4 answers
Mysql reset auto increment id
SQL
0 vote270 views1 answer
Sql query for displaying age from oldest to youngest
SQL
1 vote278 views1 answer
Mysql select another database
SQL
0 vote276 views1 answer
Sql decode
SQL
42 votes343 views6 answers
Install beautifulsoup
SQL
1 vote302 views1 answer
Altrer name column postgres
SQL
0 vote275 views1 answer
Mysql find db contarint
SQL
0 vote280 views1 answer
SQL Server Enterprise
SQL