O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Access 97's SQL Pass-Through Queries

SQL pass-through queries allow you to write queries in the dialect of SQL used by the server RDBMS. SQL Server, as an example, lets you write stored procedures that you can execute by name, instead of by sending individual SQL statements to the server. Executing a stored procedure query is faster than executing the query through the Jet database engine because of reduced network traffic and faster execution of the query by the server. (Stored procedure queries are precompiled by SQL Server.) You also need to use SQL pass-through if you want to take advantage of special Transact-SQL reserved words not included in Jet SQL. In many cases, SQL pass-through queries execute faster than queries that use Jet's ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required