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)

From

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

Note

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.