What is the difference between Temporary table variable and
a Table variable?
Or
Which Table variable I should use inside Stored procedure?
- 3 Answers
- 7168 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
Write an sql query to find first weekday of the month?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
Difference between report and query parameter.
What is join query?
What is an identity column in insert statements?
What are constraints in microsoft sql server?
Explain database normalization?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
Tell me the difference between clustered and non-clustered index?
How to test odbc dsn connection settings?
What is spid in sql server profiler?
Tell me when is the update_statistics command used?
List the ways in which dynamic sql can be executed?
What is autocommit mode in sql server?
What is transaction server isolation?
