What is similarity and difference between truncate and delete in sql?


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

Post New Answer

More SQL Server Interview Questions

What is the name of the Database which IBM mainframe uses?

0 Answers   Wipro,


How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?

2 Answers  


How can you list all the columns in a database?

0 Answers  


What are subquery and its properties?

0 Answers  


What does REVERT do in SQL Server 2005?

0 Answers   HCL,






how to delete duplicate rows in sql server2005

7 Answers   Cisco, CTS, HCL, IBM,


how to know Who Is Blocking Your SQL Server?

4 Answers  


What is create command?

0 Answers  


How to select some specific rows from a table in ms sql server?

0 Answers  


Which trace flags are enabled in sql server?

0 Answers  


Explain the etl (extraction, transformation, and loading)?

0 Answers  


Explain few examples of stored procedure over triggers?

0 Answers   ADITI,


Categories