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)》,本文关键词 t-sql,清空,表,数据,的,两种,;如发现本文内容存在版权问题,烦请提供相关信息告之我们,我们将及时沟通与处理。本站内容系统采集于网络,涉及言论、版权与本站无关。