主要介绍了t-sql使用truncate and delete清空表数据的两种方法，大家参考使用

代码如下:TRUNCATE TABLE (Transact-SQL) 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 trans