By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,671 Members | 1,280 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,671 IT Pros & Developers. It's quick & easy.

SQL 89 or 92

P: n/a
In Access Options, this can be set. I wonder if there are any good reasons
why someone should not use the latest ANSI standard of 92, considering they
develop a brand new database where no old SQL code exists.

Konstantinos
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
'92' format has some extra features, and in trivial
respects is more similar to the dialect used by SQL
Server and other SQL engines.

BTW, '92' is not the latest ANSI SQL standard, the
Access version of '92' is not particularly ANSI
compatible, and Access/Jet '89' format for all
practical purposes looks more like ANSI 92 than
it looks like any other ANSI 89 implementation.

(david)
"Konstantinos" <no*****@noemail.net> wrote in message
news:10*************@corp.supernews.com...
In Access Options, this can be set. I wonder if there are any good reasons
why someone should not use the latest ANSI standard of 92, considering they develop a brand new database where no old SQL code exists.

Konstantinos

Nov 13 '05 #2

P: n/a
Well, people do not erase their old knowledge of Access with a new database,
or the zillions of lines of sample code. right?
--
MichKa [MS]
NLS Collation/Locale/Keyboard Technical Lead
Globalization Infrastructure and Font Technologies
Windows International Division

This posting is provided "AS IS" with
no warranties, and confers no rights.

"Konstantinos" <no*****@noemail.net> wrote in message
news:10*************@corp.supernews.com...
In Access Options, this can be set. I wonder if there are any good reasons
why someone should not use the latest ANSI standard of 92, considering they develop a brand new database where no old SQL code exists.

Konstantinos

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.