| SQL: Access to SQL Server Contributor(s): Sales Harkins, Susan (Author), Reid, Martin (Author) |
|
 |
ISBN: 1893115305 ISBN-13: 9781893115309 Publisher: Apress OUR PRICE: $44.99 Product Type: Paperback Published: January 2002 Annotation: This guide includes a handy appendix with a table comparing Jet SQL, Access SQL, and SQL Server's T-SQL dialects. Another appendix contains problem-solving solutions. It features time-saving information on upsizing from Access to SQL Server, how to leverage new features in Access 2002 when working with SQL Server, and advice and tips from industry pundits. |
| Additional Information |
| BISAC Categories: - Computers | Programming Languages - Sql - Computers | Desktop Applications - Databases - Computers | Databases - General |
| Dewey: 005.756 |
| Physical Information: 1.55" H x 7.43" W x 9.27" (2.60 lbs) 698 pages |
| Descriptions, Reviews, Etc. |
| Publisher Description: This is the first book of its kind! Microsoft Access uses a specific dialect of SQL known as Jet SQL to communicate with the Jet Engine. This book shows you how to talk directly to the Jet, bypassing the query design window. Why would you want to? You can't really take advantage of all the Jet has to offer until you can speak its language. The first part teaches you the rules and syntax you'll need to master to talk Jet SQL. The second and third sections show you how to upside an Access database to an Access Project and discusses some of the changes the Access Developer will face when working with SQL Server, including Stored Procedures, Functions, and Views. These sections are full of helpful hints and warnings. "Access SQL to SQL Server Desktop Edition and Beyond" is more than just a comprehensive reference tool for Jet SQL. You'll also find efficient SQL solutions for common Access problems and tasks, in addition to helpful hints and warnings about what to avoid. Learning Jet SQL is an important step from using Access to developing with Access. Understanding Jet SQL opens new possibilities to more efficient solutions that are easier to build than convention methods - once you know the language. |