On 12/9/2010 11:30 AM, Vander Clock Stephane wrote:

>
> i select the rows only like this
>
> select * from ZillionRows where OBJECTID=xxx;
>

Since you bring it up, let me rant a moment on one of
my favorite topics.

<rant>
The *worst* feature in SQL is "select *". It's a holdover
from an interactive pedagogical language circa 1974 that
has no place in a programming language. It defeats the
use of one of the major features of relational databases -
the separation of logical and physical storage. If you
realize after you've built your application that you really
need a Skype handle as well as a phone number, just add it.
As long as you've used field names in your queries, everything
old works just the way it did and new queries and updated
queries can use the Skype handle. But put one Select *
into the mix and you've got chaos.

The second worst is an insert without a target field list.
I won't bore you with the third through 400th worst features
of SQL.
</rant>

Ann