Posted by Erland Sommarskog on 06/16/85 11:31

Dan Guzman (guzmanda@nospam-online.sbcglobal.net) writes:
> I agree that SELECT * should be avoided but I wouldn't go as far as to say
> that sp_refreshview isn't needed when an explicit column list is
> specified. The view meta data may still get out-of-sync. This probably
> isn't a show-stopper but this looks to be like an accident waiting to
> happen.

OK, I change my statement to say that views should not be used. :-) That
would prevent me from saying silly things on the newsgroups.

Thanks for the correction, Dan.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: How to do a JOIN statement for a table with 2, one-to-many relationships.
• Prev in forum: [ANNOUNCE] XQuery FLWOR Tutorial
• Thread view: Re: Question about Views and sp_refreshviews

[Reply to this message]