|
Posted by Tony Rogerson on 04/03/06 19:08
> There are no problems with nesed VIEWs and in fact, you can do some
> neat tricks using the WITH CHECK OPTION at various levels of the
> nesting.
>
So you have never tried to diagnose performance or bugs in code developed by
a third party using nested views then?
Nested views are a maintanence nightmare and should be avoided at all cost.
> The real trick is to make sure that the VIEWs have sensible names and
> meanings.
The real trick is to think through what you are trying to do and design your
schema properly in the first place.
--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
"--CELKO--" <jcelko212@earthlink.net> wrote in message
news:1144051881.283954.296270@v46g2000cwv.googlegroups.com...
> There are no problems with nesed VIEWs and in fact, you can do some
> neat tricks using the WITH CHECK OPTION at various levels of the
> nesting.
>
> The real trick is to make sure that the VIEWs have sensible names and
> meanings.
>
Navigation:
[Reply to this message]
|