Truncate or Delete ?
What is the difference when doing a DELETE TableA instead of TRUNCATE TableA?
Raymond have better answer for this question.
For me, i always use truncate if i need to clear all the data in a tables. It is much more faster. 
me,myself,english and programming..
Pages
Archives
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- May 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- August 2007
- July 2007
- June 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
- December 2006
- November 2006
- October 2006
- September 2006
Categories
- *nix (17)
- :Else: (18)
- AutoIt (5)
- BlackBerry (5)
- Database (25)
- Learn English (6)
- My Life (117)
- Programming (17)
- Security (1)
- SQL/ETL (26)
- Tips & Tricks (28)
