What is the difference between delete and truncate statements?


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

Post New Answer

More SQL Server Interview Questions

What are the types of lock supported by ?

0 Answers   HCL,


Magic Tables ?

2 Answers   Thomson Reuters,


sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??

2 Answers  


what authentication modes does sql server support? : Sql server database administration

0 Answers  


What does sql server mean?

0 Answers  






What are the different types of collation sensitivity in sql server?

0 Answers  


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

0 Answers  


How to convert a numeric expression from one data type to another?

0 Answers  


How do you Implement SSIS Packages in your Project?

0 Answers  


which table keeps the locking information? : Sql server administration

0 Answers  


How fixed length strings are truncated and padded?

0 Answers  


You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

0 Answers  


Categories