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: 139
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.
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