/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

0 vote337 views1 answer
Max length found in mysql
SQL
0 vote302 views1 answer
Vbscript create ADODB.Connection
SQL
0 vote345 views1 answer
Mysql 8 geo to json
SQL
49 votes375 views6 answers
Alter table add column
SQL
0 vote333 views1 answer
Like date sql server not working
SQL
39 votes384 views5 answers
Sql drop column
SQL
0 vote344 views1 answer
How to remove quotes from a string in ssis load file
SQL
5 votes349 views2 answers
Mysqldump password
SQL
1 vote264 views1 answer
Ms sql - add one hour to time
SQL
0 vote338 views5 answers
Sql table intermédiaire
SQL