.
- CREATE VIEW ANSI_NULLS QUOTED_IDENTIFIER ON. OBJECTPROPERTY ExecIsAnsiNullsOn ExecIsQuotedIdentOn.
- CREATE TABLE , , ANSI_NULLS ON.
- , .
- , , , , , .
- SCHEMABINDING. .
- , , SCHEMABINDING.
- , , . , .
- , , .
- , 80 .
90 , , . , , , . , , , LANGUAGE DATEFORMAT , . - , SELECT COUNT_BIG (*).
- NO SQL, NO.
- SELECT Transact-SQL.
- * table_name. * . .
- , , . , , ( , ) .
, :
SELECT ColumnA, ColumnB, ColumnA
:
SELECT SUM(ColumnA) AS SumColA, ColumnA % ColumnB AS ModuloColAColB, COUNT_BIG(*) AS cBig FROM dbo.T1 GROUP BY ModuloColAColB- , GROUP BY, .
- UNION, EXCEPT INTERSECT.
- .
- .
- TOP.
- ORDER BY.
- DISTINCT.
- COUNT (COUNT_BIG(*) ).
- AVG, MAX, MIN, STDEV, STDEVP, VAR VARP.
- SUM, , NULL.
, , . . , . , .
|
|
CREATE INDEX , CREATE INDEX.
- , CREATE INDEX, .
- CREATE INDEX ON SET.
- ANSI_NULLS
- ANSI_PADDING
- ANSI_WARNINGS
- CONCAT_NULL_YIELDS_NULL
- QUOTED_IDENTIFIER
- NUMERIC_ROUNDABORT OFF. .
- 80 , ARITHABORT ON.
- IGNORE_DUP_KEY OFF ( ).
- text, ntext image, CREATE INDEX.
- SELECT GROUP BY, , GROUP BY.
- , , . , . .
, , , . , , , SQL Server INSERT, UPDATE DELETE, .
. . , , . . , , .
CREATE UNIQUE CLUSTERED INDEX , , . , , .
|
|
, , . .
- WITH SCHEMABINDING.
- , , . , FROM .
, .
. , .
--
SET NUMERIC_ROUNDABORT OFF;
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON;
GO
-- SCHEMABINDING
CREATE VIEW Sales.vOrders
WITH SCHEMABINDING
AS
SELECT SUM(UnitPrice*OrderQty*(1.00-UnitPriceDiscount)) AS Revenue,
OrderDate, ProductID, COUNT_BIG(*) AS COUNT
FROM Sales.SalesOrderDetail AS od, Sales.SalesOrderHeader AS o
WHERE od.SalesOrderID = o.SalesOrderID
GROUP BY OrderDate, ProductID;
GO
--
CREATE UNIQUE CLUSTERED INDEX IDX_V1
ON Sales.vOrders (OrderDate, ProductID);
GO
17