sql server 实例功能（SQL Server简单查询示例汇总）

USE TSQL2012
GO
SELECT orderid, orderdate, custid, empid
FROM Sales.Orders
WHERE orderdate = DATEADD(MONTH, DATEDIFF(MONTH, '19991231', orderdate), '19991231')

SELECT orderid, orderdate, custid, empid
FROM Sales.Orders
WHERE orderdate = EOMONTH(orderdate)

USE TSQL2012
GO
SELECT orderid,SUM(unitprice *qty) AS TotalValue
FROM Sales.OrderDetails
GROUP BY orderid
HAVING SUM(unitprice *qty) > 10000
ORDER BY TotalValue DESC

SELECT orderid
FROM Sales.OrderDetails
WHERE orderid >10357
GROUP BY orderid
SELECT orderid
FROM Sales.OrderDetails
GROUP BY orderid
HAVING orderid >10357

SELECT orderid
FROM Sales.OrderDetails
WHERE COUNT(qty * unitprice) >10000
GROUP BY orderid
SELECT orderid
FROM Sales.OrderDetails
GROUP BY orderid
HAVING COUNT(qty * unitprice) >10000

NSERT INTO TABLE …
SELECT TOP (N) Cols…
FROM Table

INSERT TOP(N) INTO TABLE …
SELECT Cols…
FROM Table

CREATE TABLE TestValue(ID INT)
INSERT INTO TestValue (ID)
SELECT 1
UNION ALL
SELECT 2
UNION ALL
SELECT 3
UNION ALL
SELECT 4
UNION ALL
SELECT 5

USE TSQL2012
GO
CREATE TABLE InsertTestValue (ID INT)
CREATE TABLE InsertTestValue1 (ID INT)

INSERT INTO InsertTestValue (ID)
SELECT TOP (2) ID
FROM TestValue
ORDER BY ID DESC
GO

INSERT TOP (2) INTO InsertTestValue1 (ID)
SELECT ID
FROM TestValue
ORDER BY ID DESC
GO

SELECT *
FROM InsertTestValue
GO
SELECT *
FROM InsertTestValue1
GO

CREATE TABLE TestData
(
  Id INT NOT NULL IDENTITY PRIMARY KEY,
  NAME VARCHAR(max) NULL
);

USE TSQL2012
GO
SELECT COUNT(NAME) AS COUNT_NAME
FROM dbo.TestData
SELECT COUNT(ALL NAME) AS COUNT_ALLNAME
FROM dbo.TestData
SELECT COUNT(DISTINCT NAME) AS COUNT_DISTINCTNAME
FROM dbo.TestData