News

```sql SELECT p.FirstName, p.LastName, DATEADD (day, ROW_NUMBER () OVER (ORDER BY a.PostalCode), SYSDATETIME ()) AS 'Row Number' FROM Sales.SalesPerson AS s INNER JOIN Person.Person AS p ON ...
year, yyyy, yy = Year, which is the specified year to be added. quarter, qq, q = Quarter, which is the specified quarter to be added. month, mm, m = month, which is the specified month to be added.