DELETE

This lesson uses DDI_SQL_Training dataset v1.0.0 on SQL Server 2019 or later. Remove selected rows from a disposable copy while preserving canonical tables. Run changing examples only on a disposable training instance. The example uses a session-local object or rolls back its changes.

Run the example

SELECT ProductID, ProductName INTO #PracticeProducts
FROM dbo.Products WHERE ProductID BETWEEN 1 AND 3;
DELETE FROM #PracticeProducts WHERE ProductID = 3;
SELECT ProductID, ProductName FROM #PracticeProducts ORDER BY ProductID;
DROP TABLE #PracticeProducts;

Read it step by step

1. SELECT INTO creates a session-local temporary copy of three product rows.
2. DELETE removes only ProductID 3 from that copy.
3. The final SELECT shows the two survivors; dropping the temp table leaves the canonical Products table unchanged.

Check the result

ProductID 3 still exists in dbo.Products.

Practice

Create the same three-product temp copy, delete ProductID 2, and show the survivors.

SELECT ProductID, ProductName INTO #PracticeProducts
FROM dbo.Products WHERE ProductID BETWEEN 1 AND 3;
DELETE FROM #PracticeProducts WHERE ProductID = 2;
SELECT ProductID, ProductName FROM #PracticeProducts ORDER BY ProductID;
DROP TABLE #PracticeProducts;