karthikeyan-444867 (8/20/2008)
Mark,you are right. But OP mentioned like
Query to delete, all the records from a table
Thats why i preferred TRUNCATE.
But that's only a part of what the OP wants. You cut off the other very important part that makes TRUNCATE the wrong choice in this case...
Query to delete, all the records from a table [font="Arial Black"]before half an hour[/font],…
--Jeff Moden
Change is inevitable... Change for the better is not.