O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required