Give main 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

Can you explain the disadvantages/limitation of the cursor?

0 Answers  


What is the primary use of the model database?

0 Answers  


what is new philosophy for database devises for sql server 7.0? : Sql server database administration

0 Answers  


On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

0 Answers  


What is the difference between stored procedure and functions?

0 Answers   MCN Solutions,






What is Schema? and why we use schemas?

4 Answers  


How many types of Cursor in SQL SERVER?

1 Answers  


What are Magic Table?

34 Answers   3i Infotech, Digiweb, Evalueserve, NIIT, PL,


What happens if strings are casted into wrong code pages in ms sql server?

0 Answers  


How many non clustered indexes there can be on table ?

0 Answers  


What is the difference between a function and a stored procedure?

0 Answers  


What do you understand by recursive stored procedures?

0 Answers  


Categories