SQL syntax

[Ruslan Zasukhin]

On 9/2/09 12:47 AM, "Steve Albin" <steve at steve-albin.com> wrote:

Hi Steve,

I do not see such advices ...

I like only two

A) use fldName, tblName, lName   prefixes

B) use SQL binding - for effectiveness.

Also good advice -- use Stored Procedures.


> This has since been fixed a while back but I have lots of
> queries in my app that included unused fields in the SELECT
> clause to work around this bug and they are still there.  Of
> course, these bloated SQL queries still work, but I would like
> to remove these fields from the query  It occurs to me that
> maybe this is bad practice.  In other words, could there be any
> other "gotchas" - not bugs, but bad SQL programming practices -
> that I should consider before trimming down the SELECT clauses
> to not include fields in the WHERE and ORDER BY clause?

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]