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 can I know what locks are running on which resource?
What is the difference between a primary key and a unique key? Are they the same?
How use inner join in sql server?
How many partitions a clustered index has by default in sql server 2012?
Tell me what is fill factor?
What are the different types of triggers in SQL SERVER?
how you can move data or databases between servers and databases in sql server? : Sql server administration
How do I install sql server?
What is the meaning of resultset type_scroll_insensitive?
How many replicas are maintained for each sql azure db?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
when you create a database how is it stored? : Sql server database administration
What is transact-sql language?
How would you add a section to a table?
Do you know what are the restrictions that views have to follow?