EXACTLY! The table is renamed to something else and the view is given the table name. The "Instead of" triggers are used to make it all work seamlessly for Inserts, Updates, and Deletes as if it were a single table rather than a multi-table view and it all requires precisely ZERO changes to the application. Being a "pass-through" view, Selects enjoy all of the benefits of the underlying indexes on the tables, as well.
is pronounced "ree-bar
" and is a "Modenism
" for R
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".
"Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)