/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

3 votes336 views2 answers
Enter mysql command line
SQL
0 vote344 views1 answer
How to start my sql server on mac
SQL
0 vote343 views2 answers
Mysql on update current_timestamp
SQL
11 votes349 views3 answers
Sql line numbers
SQL
1 vote307 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
0 vote322 views1 answer
Sqlite3 pragma foreign keys
SQL
0 vote332 views2 answers
Mysql row_number() example
SQL
0 vote353 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
0 vote351 views1 answer
In query in sql
SQL
-2 votes329 views1 answer
Remove root password mysql
SQL