sql-scripts-remember/scripts/21_Temporary_Tables.sql at main · DishaniD/sql-scripts-remember · GitHub

29 lines (26 loc) · 1.16 KB

/* ==============================================================================

SQL Temporary Tables

-------------------------------------------------------------------------------

This script provides a generic example of data migration using a temporary

table.

=================================================================================

/* ==============================================================================

Step 1: Create Temporary Table (#Orders)

============================================================================== */

SELECT

INTO #Orders

FROM Sales.Orders;

/* ==============================================================================

Step 2: Clean Data in Temporary Table

============================================================================== */

DELETE FROM #Orders

WHERE OrderStatus = 'Delivered';

/* ==============================================================================

Step 3: Load Cleaned Data into Permanent Table (Sales.OrdersTest)

============================================================================== */

SELECT

INTO Sales.OrdersTest

FROM #Orders;

Expand file tree