Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calculated column name with spaces
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01510215
Message ID:
01510221
Views:
33
>>>As, it's fine. You can use [] also (I prefer [] delimiters for such names).
>>
>>So, is this SQL ANSI?
>
>:-)
>I know that all other RDBMS also support this, so I really don't care much if it is ANSI standard or not.
>
>But here what I found (not sure if this true or not)
>http://www.elevatesoft.com/manual?action=viewtopic&id=dbisam4&product=d&version=5&topic=naming_conventions
>
>ANSI-standard SQL specifies that each column name be a single word comprised of alphanumeric characters and the underscore symbol (_).

Boris,

Here is George Mastros blog on this topic

http://blogs.lessthandot.com/index.php/DataMgmt/DBProgramming/do-not-use-spaces-or-other-invalid-chara
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform