Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Dealing with reserved words
Message
De
07/03/2008 00:49:30
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Titre:
Dealing with reserved words
Divers
Thread ID:
01299625
Message ID:
01299625
Vues:
54
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform