/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 votes340 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
0 vote339 views1 answer
Php get closest location by latitude longitude
SQL
0 vote310 views2 answers
Spring properties file for db
SQL
1 vote344 views1 answer
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
SQL
0 vote338 views1 answer
Select max salary from each department in sql
SQL
1 vote380 views1 answer
Psql filed name alter
SQL
2 votes366 views1 answer
Sql server case sensitive search
SQL
1 vote380 views2 answers
Oracle difference between two dates in seconds
SQL
-1 vote320 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
5 votes325 views1 answer
Sql first day of current year
SQL