/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 vote126 views1 answer
Increase speed of like queries postgres
SQL
0 vote119 views1 answer
Sql comparison operators
SQL
2 votes129 views2 answers
Storing timezones in postgres
SQL
0 vote129 views1 answer
Kill slow queries mysql
SQL
8 votes133 views1 answer
How to check mysql version in xampp
SQL
17 votes134 views2 answers
T_sql contains
SQL
0 vote122 views2 answers
MySQL top percent
SQL
0 vote138 views1 answer
Mysql custom sort order
SQL
8 votes127 views6 answers
Sql insert
SQL
0 vote124 views1 answer
Get week day name sql server
SQL