What’s New in Creating and Managing Views
Much of the core functionality associated with standard views has remained unchanged in SQL Server 2012. There is, however, one feature that has been removed in SQL Server 2012 that could impact views. The use of *=
and =*
in your SQL statements including views has been discontinued in SQL Server 2012. The ANSI join syntax using the JOIN
keyword should be used instead. If you have views that were created in an earlier version of SQL Server, make sure that these views are not using the *=
or =*
syntax.
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.