O'Reilly logo
  • Dustin Waybright thinks this is interesting:

CREATE VIEW Sales.OrderTotalsByYear(orderyear, qty) WITH SCHEMABINDING AS SELECT YEAR(O.orderdate), SUM(OD.qty)


Cover of Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012


Specifying the output columns as with an INSERT INTO function instead of aliasing from select. The number of columns must be the same and they must be in order.