wat new abt truncate in sql server

Answers were Sorted based on User's Feedback



wat new abt truncate in sql server..

Answer / praful chavan

While using TRUNCATE stmt, WHERE clause can not be used.
When we use TRUNCATE stmt, Trigger does not get fire. After
using TRUNCATE stmt, all the deleted rows are not entered in
the transaction log file(.ldf)

Is This Answer Correct ?    12 Yes 0 No

wat new abt truncate in sql server..

Answer / 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

More SQL Server Interview Questions

Why do we use sql limitations? Which constraints can we use while making a database in sql?

0 Answers  


List some major differences between triggers and stored procedures?

0 Answers  


how to connect sybase to sql server 2005?.

1 Answers   ABC,


Can select statements be used on views in ms sql server?

0 Answers  


Explain what is scheduled job and how to create it?

0 Answers  






What is ms sql server reporting services?

0 Answers  


Explain database normalization?

0 Answers  


What is the stuff and how does it differ from the replace function?

0 Answers  


How do SQL server 2000 and XML linked?

2 Answers  


How to enter binary string literals in ms sql server?

0 Answers  


How to write query to Delete the records in child table and corresponding records in parent table

11 Answers   Semantic Space,


What does it mean to invest in the index?

0 Answers  


Categories