Removes all rows from a table without logging the individual row deletions.
TRUNCATE TABLE is similar to the DELETE statement with no WHERE clause;
however, TRUNCATE TABLE is faster and uses fewer system and transaction log resources.
t-sql清空表数据的两种方式示例(truncate and delete)
原文:http://www.jb51.net/article/43883.htm