Give me any three 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

To which devices can a backup be created and where should these devices be located? : sql server management studio

0 Answers  


What happens if you add a new index to large table?

0 Answers  


Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 Answers  


Difference between report and query parameter. Why do we need different type of parameter?

0 Answers  


How to find related tables in sql server?

0 Answers  






How to manipulate data from one table to another table ?

0 Answers   MCN Solutions,


How to create a large table with random data for index testing in ms sql server?

0 Answers  


Explain encryption of entire databases without the need for application changes in sql server 2008?

0 Answers  


Do you know the different ddl commands in sql?

0 Answers  


How to get @@error and @@rowcount at the same time?

0 Answers  


Determine when an index is appropriate?

0 Answers  


What is the difference between lock, block and deadlock? : sql server database administration

0 Answers  


Categories