-
Syntax Variations
As this forum has set idle a bit, I would like to suggest a continuing discussion of SQL syntax variations between db's, providers etc...
For example, a common gotcha is the use of * as substitution in Access queries, which must be converted to % when issuing those queries via ADO.
Having recently worked with Access and SQL Server 2005 I have found
Access: 'Select ... WHERE [var]="value"'
SQLServer: "Select ... WHERE [var]='value'"'
Access: Select ... WHERE len(trim([var]))=value
SQLServer: Select ... WHERE len([var])=value
Access: Select .... WHERE ucase([var])=VALUE
SQLServer: Select ... WHERE [var]=VALUE 'or value or Value
trivial examples, but nice to know when upsizing code.
Stan
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules