Don't Use Reserved Words
Written by Eric Smith, Northstar Computer Systems LLC
A reader recently passed on a reminder to the rest of you to not use reserved words. While we know this in VB since VB will generally catch that type of syntax error, the suggestion was to make sure you're not doing it in your database tables. The story he related was that one of his fields was named ALL, which is a reserved word in SQL. There are some less used keywords in SQL that can trip you up like this. If SQL starts complaining about a table or query, first check to make sure your fields and table names aren't using keywords. The syntax highlighting provided by Enterprise Manager, for instance, can help you detect these bugs.
Keywords: [
SQL
]
Publication Date: 9/1/2000
|