Difference between delete table and truncate table commands, DOT NET Programming

What is the difference between DELETE TABLE and TRUNCATE TABLE commands?

Following are differences between delete & truncate commands:-

1)The DELETE TABLE syntax logs the deletes thus make the delete operation slow. The TRUNCATE table does not log any information but it logs information about deallocation of the data page of the table so TRUNCATE table is faster while the delete table is not fast.

2) The DELETE table can have criteria while TRUNCATE cannot.

3) The TRUNCATE table cannot trigger.

Posted Date: 9/24/2012 4:25:56 AM | Location : United States







Related Discussions:- Difference between delete table and truncate table commands, Assignment Help, Ask Question on Difference between delete table and truncate table commands, Get Answer, Expert's Help, Difference between delete table and truncate table commands Discussions

Write discussion on Difference between delete table and truncate table commands
Your posts are moderated
Related Questions
Project Description: College erp Erp key features: Panacea ERP Online Suite is server based college based management software. Gives Password facility for different use

I am looking individuals who have industry experience working on Microsoft Technology and Jquery ( MVC 4.5 ), who will take live online session and give training through Team Viewe

What is fundamental of published or precreated objects in Remoting? In the scenarios of the singleton or single call the objects are created dynamically. But in some situations

What is an application domain? Previously "PROCESS" were used as the security boundaries. One of the process has its own virtual memory and does not overlap the  another proces

I need Complete ERP Solution of Jeweler Manufacturing Project Description: MY Project Have Complete ERP Solution of jewellary manufacturing Process. By Using of my software y

Design an interface and add code to command buttons using case statement, to find coursework to be calculated using formula 0.6*1/6*total Mark

What is CodeDom The "CodeDom" is an object model that represents actually a source code. It is designed for language independent - once you create a "CodeDom" hierarchy for a p

inheritance real time examples

I need Simple upgrades for ASP.NET site I have an existing web solution, we need a new page for creating additional features. The current website is done in C#.NET and ASP.NET.

HWID Spoofed for Windows 7, 8 x64 Project Description: I require a simple program that will spoof my hardware id. I could be able to write the id to spoof to in the program a