|
|
Posted by Hugo Kornelis on 02/01/06 00:11
On Tue, 31 Jan 2006 01:26:51 GMT, Beowulf wrote:
>Doug wrote:
>> huh. I never knew that ordering a view was unsupported. It always has
>> worked, I bet it always will, but it is good to know.
>>
>> OTOH, if you take the EXACT same code, stuff it into a stored
>> procedure, it is guaranteed to work.
>>
>> yet another reason not ot use views.
>>
>> thanks!.
>
>I was under the impression that one cannot select from a stored
>procedure or do joins with it (the way one can treat MS Access querydefs
>as virtual tables).
>
>Unfortunately, I have a large number of views that need to be joined
>with physical tables and other views. As far as I know (entirely
>possible I'm wrong), my options are views or user-defined functions that
>return tables.
Hi Beowulf,
That's correct.
Comparing stored procedurs to views is like comparing a hammer to a saw:
they are designed for entirely different purposes, and a good carpenter
knows how to use them both.
--
Hugo Kornelis, SQL Server MVP
Navigation:
[Reply to this message]
|