| 1 |
USE AdventureWorks2022; |
| 2 |
GO |
| 3 |
IF OBJECT_ID('dbo.NewProducts', 'U') IS NOT NULL |
| 4 |
DROP TABLE dbo.NewProducts; |
| 5 |
GO |
| 6 |
ALTER DATABASE AdventureWorks2022 SET RECOVERY BULK_LOGGED; |
| 7 |
GO |
| 8 |
|
| 9 |
SELECT * INTO dbo.NewProducts |
| 10 |
FROM Production.Product |
| 11 |
WHERE ListPrice > $25 |
| 12 |
AND ListPrice < $100; |
| 13 |
GO |
| 14 |
ALTER DATABASE AdventureWorks2022 SET RECOVERY FULL; |
| 15 |
GO |
| 16 |
|
| 17 |
-- From https://learn.microsoft.com/en-us/sql/t-sql/queries/select-examples-transact-sql |
| 18 |
|
