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 create a simple table to test triggers in ms sql server?
Explain what are page splits? : SQL Server Architecture
How to optimize stored procedure optimization?
what kind of lan types do you know? : Sql server database administration
what is a deadlock? : Sql server database administration
How to find index size for each index on table?
What are the different editions available in sql server 2000?
What is a Join and explain its types?
Why do we partition data?
What is the difference between dropping a database and taking a database offline?
What is the default server name for sql server?
How to delete exactly duplicate records from a table?
What stored by the msdb?
How to defragment indexes with alter index ... Reorganize?
List the different types of joins?
