Views are useful for creating a business entity based view data while allowing for an efficient logical schema. SQL Server’s instead of triggers allow many of these views to be updatable. Here are some experiments that show how to write them and some of their properties.
