Temporary variables logs very less into transaction log, so compare to Te

What is the difference between temp table and table variable?

Question Posted / nalla

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

Please Help Members By Posting Answers For Below Questions

what are the reporting service components in SSRS?

163

What is de-normalization in sql database administration? Give examples?

962

How do you delete duplicate rows in sql server?

943

When you use @@error and try-catch?

1027

What is database white box testing?

1107

Is it possible to have clustered index on separate drive from original table location?

946

How to insert multiple rows with a subquery?

1106

How to execute multiple stored procedures at one time in sql server?

987

Name and describe few console utilities for ssrs?

284

What is normalization and what are the advantages of it?

959

What is a self join in sql server?

1110

What is mean by dml?

985

what is a mixed extent? : Sql server administration

1075

what is isolation level at dead lock?

2131

What are security principals used in sql server 2005?

953