What is the difference between Temporary table variable and
a Table variable?
Or
Which Table variable I should use inside Stored procedure?
- 3 Answers
- 7682 Views
- Microsoft, TCS, Techastrum, I also Faced
- E-Mail Answers
Answer Posted / jagadeesh
transation can be rollback in temptable
but in tablevaribale we cannot do this
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Name the different type of indexes in sql?
What is the definition for sql server 2000?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
Can we delete data from a view?
What is bcp? When does it use?
What are the differences between substr and charindex in sql server.
What is a primary index?
Explain active/passive and active/active cluster configurations?
What is isolation levels?
How to return the second 5 rows in ms sql server?
Tell me the difference between clustered and non-clustered index?
what are the reporting service components in SSRS?
Differentiate between ms sql server reporting services vs crystal reports?
What is normalization? Explain its different types?
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
