/SQL/Temp table vs variable table in sql server

Temp table vs variable table in sql server

DECLARE @TableExample TABLE(some columns); --Table variable.

CREATE TABLE #TempTable(Ssome columns); --Temporal table.

Temp tables are a good choice if you're handling large data but if it's a small
data that you'll be handling, table variable are a great choice since they operate
on the ram(memory).

Similar codes

4 votes306 views3 answers
Postgres drop all tables
SQL
0 vote250 views1 answer
Java mysql date format
SQL
0 vote273 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL
1 vote257 views1 answer
Postgres regex remove special characters
SQL
-1 vote275 views1 answer
Can pandas fetch data from sql
SQL
0 vote274 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
0 vote253 views1 answer
Query to get all primary keys and foreign key
SQL
0 vote224 views1 answer
Plsql trigger insert update
SQL
0 vote248 views1 answer
Access refused mysql xampp server
SQL
0 vote293 views1 answer
Alter domain sql
SQL