Monthly Archives: July 2014

Using INSTEAD OF Triggers to enable updatable views

Posted on July 7, 2014 by Bob L

A common misconception with SQL Server views is that only indexed views can provide update capability. Actually, any view that is schema-bound can be enabled for update by simply using an “INSTEAD OF” trigger.  Although an indexed view may also … Continue reading →

Posted in Uncategorized | Leave a comment