Answer Posted / gk
Adding to the above answer truncate may or may not be
rolled back.
It can be rolled back if it is within a transaction.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to use the inserted and deleted pseudo tables?
What is field with example?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
Why I have to use stored procedures?
Explain forward - only cursors?
Can a table have 2 foreign keys?
What is rtm version in sql server?
How to create a view with data from multiple tables?
What is the difference between a function and a stored procedure?
How network traffic be reduced by using the stored procedure?
What is subquery? Explain the properties of a subquery?
What is a database in ms sql server?
between cast and convert which function would you prefer and why?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
What is change data capture (cdc) in sql server 2008?