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

Assignment Help:

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.


Related Discussions:- Difference between delete table and truncate table commands

.net remoting, What is .NET Remoting? The .NET remoting is replacement ...

What is .NET Remoting? The .NET remoting is replacement of DCOM. Using .NET remoting you can make remote object calls that lie on different Application Domains. since the remot

Develop a new website, I need to develop a new website. Previous site was n...

I need to develop a new website. Previous site was not good and I need better one with not only static but using also more details . Skills required: .NET, MySQL, C# Programm

What happens when aspx page is requested from browser ?, The steps that occ...

The steps that occur when we request a ASPX page are as follows:- 1) The browser sends the request to the webserver. Now  assume that the webserver at the other end is IIS. 2

How can you implement a condition in a workflow, How can you implement a co...

How can you implement a condition in a workflow? You can implement a condition by using either of the following ways: By creating a rule condition - Specifies that you can e

Bug correction and prediction, Bug Correction and Prediction Project Des...

Bug Correction and Prediction Project Description: The project is about the prediction of bugs and resolves the bug in the sample program using costriage algorithm. You have

Why do we use the xmlhttprequest object in ajax, Why do we use the XMLHttpR...

Why do we use the XMLHttpRequest object in AJAX? The XMLHttpRequest object is used by JavaScript to transfer XML and other text data among client and server. The XMLHttpRequest

Full time contractual programming position, Full time contractual programmi...

Full time contractual programming position (mostly scraping, databasing) Project Description: This is a full time contractual role needed for a sports advisory service. We ar

Need desktop application for inventory system, Need desktop application for...

Need desktop application for inventory system Project Description: For my distribution unit, I want inventory system (purchase / sale / returns / reports ) based on customize

Development of online game, Project Description: Online game development...

Project Description: Online game development 1. Online Live Baccarat Game is required - server program(IOCP or ect..). - 2D graphic design. - client program. - we

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd