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
