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

DESIGN CALENDAER, HOW TO DESIEN THE CALENDER IN ASP . NET

HOW TO DESIEN THE CALENDER IN ASP . NET

C# application creates a minimal student enrolment system, This assignment ...

This assignment is about writing a C# application that creates a minimal student enrolment system. The application will display lists of papers and students. The user can enrol stu

Arithmetic progression series, code

code

Write a program of changing string order – c# program, Write a Program of C...

Write a Program of Changing String Order - C# Language using System; class Prog3_2 { public static void Main(String [] args) { Console.Write(ar

Steps to create a webservice, What are the steps to create a webservice? ...

What are the steps to create a webservice? This webservice will add 2 numbers and send to the calling client.All the below steps shown are according to VS2005 beta editor :-

What are queues and stacks, What are queues and stacks? Stacks refer to...

What are queues and stacks? Stacks refer to a list in which all items are accessed and processed on the Last-In-First-Out (LIFO) basis. In a stack, elements are inserted (push

What do you meant by the term pseudo-class as used in css, Question: (a...

Question: (a) Prepare a diagram which explains where the different elements like Form, Window and Document, belong in the Document Object Model hierarchy and how properties are

What is garbage collection, What is garbage collection? Explain the di...

What is garbage collection? Explain the difference among garbage collections in .NET 4.0 and earlier versions. Garbage collection stops memory leaks during execution of pro

I need remote chat application for desktop, I need Remote chat Application ...

I need Remote chat Application for desktop Project Description: I want a team of .net experts who will design me a website and a remote desktop chat application as like live

Difference between "dataset" and "datareader", What is the difference betwe...

What is the difference between "DataSet" and "DataReader"? The major differences between "DataSet" and "DataReader" are as follows:- 1)The "DataSet" is a disconnected archit

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages