• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 22. Upsizing Jet Applications to... > Comparing ANSI-92 SQL, T-SQL, and Je...

Comparing ANSI-92 SQL, T-SQL, and Jet SQL

Jet SQL and T-SQL don't include many of the approximately 200 keywords incorporated in the ANSI standard for SQL-92. Most of the common SQL keywords missing from Jet's implementation are provided by the expressions you create with operators, built-in functions, or user-defined functions you write in Access's VBA flavor. Understanding the similarities and differences between Jet and ANSI-92 SQL is important when you upsize Jet applications to ADP. This knowledge is even more important if you take the “planned migration” route, described near the beginning of the chapter, to upsizing your database front ends.

ANSI-92 SQL Reserved Words in Jet SQL

Access doesn't support all the ANSI SQL keywords with identical reserved words in the Jet SQL language, but each update to Jet converges on the SQL-92 standard, as does each successive version of SQL Server. In this chapter, keywords are defined as the commands and functions that make up the vocabulary of the ANSI SQL language. Jet SQL commands and functions are referred to here as reserved words to distinguish them from ANSI SQL.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint