/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 vote202 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
0 vote289 views3 answers
Get count of null in column sql
SQL
20 votes206 views5 answers
Reset auto increment mysql
SQL
3 votes193 views2 answers
Plsql print
SQL
11 votes233 views3 answers
Change column name sql server management studio
SQL
5 votes224 views1 answer
How to use rank function in sql
SQL
0 vote211 views2 answers
How to see table associated with a schema in sql
SQL
38 votes272 views4 answers
Count sql
SQL
0 vote293 views1 answer
Wordpress sql find and replace
SQL
0 vote220 views1 answer
Oracle db timestamp auto add
SQL