.


:




:

































 

 

 

 





.

  • 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





:


: 2016-11-22; !; : 779 |


:

:

- , - .
==> ...

777 - | 748 -


© 2015-2024 lektsii.org - -

: 0.015 .