SQL Server 2008 编程入门经典 第七章练习
SELECT EmployeeID, CONVERT(varchar(8), HireDate, 3) FROM HumanResources.Employee; SELECT sc.CustomerID, sc.AccountNumber FROM Sales…
SELECT EmployeeID, CONVERT(varchar(8), HireDate, 3) FROM HumanResources.Employee; SELECT sc.CustomerID, sc.AccountNumber FROM Sales…
IF NOT Exists (SELECT 'True' FROM sys.databases WHERE name = 'AdventureWorksCreate') BEGIN CREATE DATABASE AdventureWorksCreate; END ELSE…
-- Get a list of customers and the date of their first order SELECT soh.CustomerID, MIN(soh.OrderDate) AS OrderDate INTO #MinOrderDates FROM…