70-761 Flashcards Preview

CAE > 70-761 > Flashcards

Flashcards in 70-761 Deck (93)
Loading flashcards...
91

Do not use parenthesis in SP

CREATE PROCEDURE usp_Customers @Count int
AS
SELECT TOP(@Count) Customers.LastName
FROM Customers
ORDER BY Customers.LastName

92

DATENAME parameters:

MONTH: mm, m
DAYOFYEAR: dy, y
WEEK: wk, ww
WEEKDAY: dw, w
HOUR: hh
MINTUE: mi, n
SECOND: ss, s

93

Creating temporal tables

, [ValidFrom] datetime2 (2) GENERATED ALWAYS AS ROW START
, [ValidTo] datetime2 (2) GENERATED ALWAYS AS ROW END
, PERIOD FOR SYSTEM_TIME (ValidFrom, ValidTo)
)
WITH (SYSTEM_VERSIONING = ON (HISTORY_TABLE = dbo.EmployeeHistory));