SQL View: Beyond the Basics

Posted on SQL Server Central See other posts from SQL Server Central
Published on Thu, 21 Jun 2012 06:00:00 UT Indexed on 2012/06/23 15:20 UTC
Read the original article Hit count: 136

Filed under:

Joe Celko delves into the main uses of views, explains how the WITH CHECK OPTION works, and demonstrates how the INSTEAD OF trigger can be used in those cases where views cannot be updatable.

SQL Monitor What are your servers really trying to tell you?
Find out with new SQL Monitor 3.0, an easy-to-use
tool built for no-nonsense database professionals.
For effortless insights into SQL Server,
download a free trial today.

© SQL Server Central or respective owner