/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

2 votes295 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
-1 vote316 views1 answer
How to Activate the database
SQL
0 vote284 views1 answer
Get date ISO in psql
SQL
0 vote280 views1 answer
List all permissions on a table in postgres
SQL
0 vote264 views1 answer
Tsql default value when no value returned by query
SQL
1 vote260 views1 answer
Mysql select month and year
SQL
0 vote290 views1 answer
Mysql disable triggers
SQL
1 vote273 views1 answer
Mysql check table exists
SQL
1 vote266 views1 answer
Sql server get users
SQL
0 vote284 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL