Posted by Jerry Stuckle on 11/11/07 14:05

AnrDaemon wrote:
> Greetings, Steve.
> In reply to Your message dated Friday, November 9, 2007, 13:05:21,
>
>>> As far as field names is a strings, You can use any given name, even in
>>> Your
>>> local encoding, and You can use spaces too.
>
>> no, it's an alias for an object really. but, yes, you can name it whatever
>> you wish. there is plenty of documentation in *every* db about avoiding such
>> conventions, esp. reserved words as dbo names, like the plague.
>
>>>> Then you don't need the quotes - which, BTW, are a MySQL extension to
>>>> the SQL standard and won't work on any other RDBMS I'm familiar with.
>>> MS SQL Server use square brackets in the same way.
>
>> so, you admit that mssql uses something DIFFERENT and PARTICULAR to alias?
>> you realize that your code becomes TIED to that db until you rewrite every
>> query to fit the NEXT db you want to use, don't you?
>
> MS SQL uses different addressing schema anyway.
> I always keep query sting templates in separate file, like localization
> templates.
> And I store them as constants to avoid modification at the time of script
> execution.
> So moving to different database is not a great issue. Smaller than
> localization process.
>
>

Why complicate things by putting SQL statements in a different file
where you can't see them? And why go to all that hassle when you can
use ANSI-compliant SQL and have it work on virtually every database
(except MS Access)? Complicates things unnecessarily, IMHO.

There has been nothing in this thread which is non-ANSWI SQL - except
for the use of a reserved word in a column name.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]