wat new abt truncate in sql server

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


Please Help Members By Posting Answers For Below Questions

How can I know what locks are running on which resource?

494


What is the difference between a primary key and a unique key? Are they the same?

536


How use inner join in sql server?

609


How many partitions a clustered index has by default in sql server 2012?

656


Tell me what is fill factor?

549






What are the different types of triggers in SQL SERVER?

533


how you can move data or databases between servers and databases in sql server? : Sql server administration

479


How do I install sql server?

455


What is the meaning of resultset type_scroll_insensitive?

559


How many replicas are maintained for each sql azure db?

104


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

530


when you create a database how is it stored? : Sql server database administration

487


What is transact-sql language?

574


How would you add a section to a table?

562


Do you know what are the restrictions that views have to follow?

618