SqlServer2008实例14 DELETE

1.删除行

use AdventureWorks go --做一个示例表并填充上行 SELECT * INTO production.Example_ProductProductPhoto From Production.ProductProductPhoto go --删除所有行 DELETE production.Example_ProductProductPhoto go use AdventureWorks go --做一个示例表并填充上行 SELECT * INTO production.Example_ProductProductPhoto From Production.ProductProductPhoto go --删除条件行 DELETE production.Example_ProductProductPhoto WHERE ProductID NOT IN ( SELECT Productid FROM Production.Product ) use AdventureWorks go DELETE Production.ProductProductPhoto FROM Production.example_productproductPhoto ppp LEFT OUTER JOIN Production.Product p ON ppp.productID=p.ProductID WHERE p.ProductID IS NULL

2.截断表

use AdventureWorks go SELECT * INTO sales.Example_Store From Sales.Store go TRUNCATE TABLE Sales.example_Store go SELECT COUNT(*) FROM Sales.example_Store go