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
Explain intellisense for query editing
What is the difference between a unique key and primary key?
What are “phantom rows”?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
What are different type of Collation Sensitivity?
Explain partitioned view?
When would you use sql joins?
What is the importance of three tier architecture?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
How to specify the collation for a character data type in ms sql server?
What are different backups available in sql server?
When columns are added to existing tables, what do they initially contain?
How to deploy the Report?
What does truncate do?
what is normalization? Explain different levels of normalization? : Sql server database administration