Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dealing with reserved words
Message
From
07/03/2008 00:49:30
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Dealing with reserved words
Miscellaneous
Thread ID:
01299625
Message ID:
01299625
Views:
53
In my framework, based on the backend, the SQL are being adjusted in regards to the reserved words. Until now, I never had to deal with that in the client application, as at that level, all the code is ANSI SQL compliant. But, exceptionnally, at one place in the client application, I have a SQL that is based on a table named Table. So, as I wanted to always have generic code at the client application level, I can see two approaches. Where needed, I can call a method which will help me to generate that SQL based on reserved words. The second one would be to know if there would be a setting in SQL Server that would allow me to run a SQL like this without any problem:
SELECT Table.Numero FROM Table
Any comment?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Next
Reply
Map
View

Click here to load this message in the networking platform