What is the difference between temp table and table variable?

Answer Posted / samba shiva reddy . m

temp tables physically exists in temp DB
but temp variables does not exists.

Is This Answer Correct ?    4 Yes 13 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are isolation levels? : Sql server database administration

657


What do you understand by triggers?

685


How can we delete Duplicate row in table?

790


What are the types of lock supported by ?

781


What is a hint?

738






What do you mean by the term 'normalization'?

857


How to end a stored procedure properly in ms sql server?

750


What is a scheduled job or what is a scheduled task?

708


What is bcp? When does it use?

671


What are triggers? How do you invoke a trigger on demand?

964


what is datawarehouse?

830


what are the critical issues you have resloved in your company

1726


What is the significance of null value and why should we avoid permitting null values?

723


Explain Reporting Life Cycle?

102


What are wait types?

736