/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

1 vote308 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
0 vote275 views1 answer
How to save data in database in mysql node
SQL
7 votes286 views2 answers
Mysql db size
SQL
2 votes277 views1 answer
Create table with primary key
SQL
0 vote273 views1 answer
How to change the field size of an existing column
SQL
0 vote297 views1 answer
Mysql query to select the highest value
SQL
0 vote310 views1 answer
Shows all databases created by user in ms sql
SQL
10 votes279 views2 answers
Sql merge statement
SQL
0 vote296 views1 answer
Helptext in sql
SQL
0 vote288 views1 answer
How to execute stored output to csv files
SQL