What is the difference between temp table and table variable?
- 8 Answers
- 25087 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / nalla
Temporary variables logs very less into transaction log, so
compare to Temp tables, temp varaibles are good in
performance wise.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a DBMS, query, SQL?
Where are stored procedures in sql server?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
Who developed sql server?
What are the advantages of user-defined functions over stored procedures in sql server?
Explain how you can configure a running aggregate in SSRS?
Determine how to use the inserted and deleted pseudo tables?
Which rendering formats are affected by the pagesize properties?
What is cross join in sql server joins?
Can two tables share the same primary key?
What is the difference between createstatement and preparedstatement?
What is advantage data architect?
What are the authentication modes in sql server? How can it be changed?
Does a full backup include transaction log?
How do you delete duplicate rows in sql server?
