1.删除 1)删除记录 Delete from 表名 where 2)删除所有数据,并回归初始化标识字段。 Truncate table 表名 3)delete与truncate区别 a. truncate是能使种子回到初始值 b. truncate不能加条件 c. 1.删除 1)删除记录 Delete from 表名 where id ='xx' 2)删除所有数据,并回归初始化标识字
复制代码 代码如下: 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, TR