What is the difference between truncate and delete commands?


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

Post New Answer

More SQL Server Interview Questions

Why use update_statistics command in sql server?

0 Answers  


When I delete any data from a table, does the sql server reduce the size of that table?

0 Answers  


How will you decide the active and passive nodes?

0 Answers  


We create an index to fast the search. How it fast the query? Do we write any special keyword with query?

3 Answers  


select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.

8 Answers   TCS,






What is master database? : SQL Server Architecture

0 Answers  


Is mysql the same as sql server?

0 Answers  


What is indexing?

0 Answers   AOL,


If i am handling 150 servers then how to check the active jobs of all the servers?

0 Answers  


What is dataset and its uses

2 Answers  


Explain candidate key, alternate key, and composite key?

0 Answers  


Does order by actually change the order of the data in the tables or does it just change the output?

0 Answers  


Categories