Fun stuff with SQL Server
SQL Server: Tables, Views and missing columns
When it comes to non-schema-bound-views (NSB View) it is important to remember that there is no schema bound between objects used in the view and metadata for a view. Let’s look at the following scenario: An attempt to use the view would give the following result: So far we are OK. Read more…