Posted by RickW on 03/24/06 00:36

I am absolutely fascinated by the complete lack of ability of the
theory-side respondents to differentiate between a thing in SQL Server
that accidentally has the object name "view", and the theoretical
construct defined by the term <VIEW>.

Amusingly, the accidental fact that there doesn't happen to be a
contravening definition of a construct named <STORED PROCEDURE> causes
them to accept without noticing any contradiction that it therefore
makes sense for an object in SQL Server with object name "stored
procedure" to return an ordered set.

Theory absolutely rules, right up to that layer where the tool meets the
real world. Right there, at that interface, you start accommodating how
a thing must be used (user interface), by adapting the things that must
work a certain way (underlying mechanisms).

Failure to do so leads to the kind of nonesense that just happened with
ORDER BY.


Science is organized common sense where many a beautiful theory was
killed by an ugly fact. -- Thomas Huxley

*** Sent via Developersdex http://www.developersdex.com ***

[Back to original message]