/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 votes357 views1 answer
Sql ends with string
SQL
0 vote337 views1 answer
2020 new year
SQL
12 votes354 views4 answers
Mysql get date difference in hours
SQL
11 votes379 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
4 votes338 views1 answer
Check database name postgresql
SQL
12 votes386 views2 answers
Insert multiple rows from another table sql
SQL
0 vote341 views1 answer
Download mysql database to excel in android studio
SQL
10 votes390 views2 answers
Mysql remove only_full_group_by permanently
SQL
3 votes380 views1 answer
Sql case update
SQL
0 vote344 views1 answer
Pl sql constraint user function
SQL