Temp table is a table created temporarily in memory. Temp variable is a variable that holds temporary data.

• Temp table is used to store data temporarily during a session

• Temp variable is used to hold te...read more

Temp TableTable VariableA Temp table is easy to create and back up data.Table variable involves effort when you usually create normal tables.Temp table results can be used by multiple users.The table ...read more

In SQL the temporary table is nothing but GTT. Here we can manage the data session wise temporarily. It is very helpful to do the bulk dml operation. If we use GTT the hitting of master table can be p...read more

Temp Tables - A Temp table is easy to creat and back up data.

Temp Table result can be used by multiple users.

Temp table can do all the DDL operations. It allows creating the indexes, dropping, alterin...read more

Temp table: It is a temporary table where data can be stored and can perform the CRUD actions as per requirement Temp Variable: It is a variable used while DECLARE statement and assign some value whic...read more

Temp tables holding a temporary records in table and temp variable holds temporary values in  varible