Sql server® 2012 t-sql fundamentals

288  

Microsoft SQL Server 2012 T-SQL Fundamentals

1-1

Insert into the dbo.Customers table a row with:

■

■

custid: 100

■

■

companyname: Coho Winery

■

■

country: USA

■

■

region: WA

■

■

city: Redmond

1-2

Insert into the dbo.Customers table all customers from Sales.Customers who placed orders.

1-3

Use a SELECT INTO statement to create and populate the dbo.Orders table with orders from the 

Sales.Orders table that were placed in the years 2006 through 2008. Note that this exercise can only 

 be practiced in an on-premises SQL Server, because SQL Database doesn’t support the SELECT INTO 

statement. In SQL Database, use a CREATE TABLE and INSERT SELECT statements instead.

2

Delete from the dbo.Orders table orders that were placed before August 2006. Use the OUTPUT 

clause to return the orderid and orderdate of the deleted orders.

■

■

Desired output:

orderid     orderdate 

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

10248       2006-07-04 00:00:00.000 

10249       2006-07-05 00:00:00.000 

10250       2006-07-08 00:00:00.000 

10251       2006-07-08 00:00:00.000 

10252       2006-07-09 00:00:00.000 

10253       2006-07-10 00:00:00.000 

10254       2006-07-11 00:00:00.000 

10255       2006-07-12 00:00:00.000 

10256       2006-07-15 00:00:00.000 

10257       2006-07-16 00:00:00.000 

10258       2006-07-17 00:00:00.000 

10259       2006-07-18 00:00:00.000 

10260       2006-07-19 00:00:00.000 

10261       2006-07-19 00:00:00.000 

10262       2006-07-22 00:00:00.000 

10263       2006-07-23 00:00:00.000 

10264       2006-07-24 00:00:00.000 

www.it-ebooks.info

---