Give main differences between "Truncate" and "Delete".


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

How to recreate an existing index in ms sql server?

0 Answers  


you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

0 Answers  


Is sql server difficult to learn?

0 Answers  


How to add a new column to an existing table with "alter table ... Add" in ms sql server?

0 Answers  


How many types of system privileges are there, Can we add or delete privileges?

2 Answers  






CLR Integration ? what is Notification services ?

1 Answers   HCL, Satyam,


How to generate create function script on an existing function?

0 Answers  


Explain transaction isolation levels in sql server?

0 Answers  


Accidentally i deleted my table. How can i get that table?

4 Answers  


What is the log shipping?

0 Answers  


Where can you add custom error messages to sql server?

0 Answers  


How do we rollback the table data in SQL Server

3 Answers  


Categories