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