What is difference between delete and truncate commands?


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

Post New Answer

More SQL Server Interview Questions

Can anyone explain difference between Database, Data warehouse and Data mart with some example?````

4 Answers  


Is it possible to delete duplicate rows in a table without using a temporary table ?

12 Answers   TCS,


Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.

3 Answers   247Customer,


What command is used to create a database in the sql server and how?

0 Answers  


What is create command?

0 Answers  






what is difference between view and Dip.

0 Answers   IBM, L&T,


What is the difference between function and stored procedure in sql server?

0 Answers  


What is postgresql server?

0 Answers  


How to check if stored procedure is running in sql server?

0 Answers  


List out the differences between global and local temp tables in sql server?

0 Answers  


How to Check Whether a Global Temporary Exists in a SQL Database or not?

2 Answers  


What is the purpose of UPDATE STATISTICS?

2 Answers  


Categories