Discussion on:

Message 4 of 4
0 Votes
+ -
Another case of a little knowledge is
dangerous.
Oh you can treat them just like tables. Well true unoptimised, unrelated, unkeyed, unnormalised badly designed tables.

Another thing if you are going to use a view inside a stored procedure, check to see whether the sp will automatically be re-parsed if the view changes. Ran into that one in SQL Server 6.5. Changed the view, but it had pasted in the query that drove it so the sp was still working on the old design. Went mental 'til I figured that out, think that was the last time I used one as well.
Posted by Tony Hopkinson
27th Jan 2006