O'Reilly logo

SQL All-in-One For Dummies®, 2nd Edition by Allen G. Taylor

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

Chapter 2: Interfacing SQL to a Procedural Language

In This Chapter

arrow Interfacing procedural language programs with Microsoft Access

arrow Giving Microsoft SQL Server a shot

arrow Doing the same with MySQL

arrow Oracle 11g’s turn

arrow Ending with IBM DB2

You can’t build a user-friendly database application with SQL alone. SQL is a data sublanguage and as such lacks many of the facilities required to build a user interface or even execute a sequence of steps. Building a moderately sophisticated application that uses the data in a database requires a procedural language in addition to SQL. Most database management systems (DBMSs) offer compatibility with several procedural languages. Which ones in particular are offered depends on the source of the DBMS and its history, as well as considerations of what capabilities users are most likely to need. In this chapter, I discuss the most common ways of connecting and interfacing to the most popular DBMS products: Access, SQL Server, MySQL, Oracle 10g, and IBM DB2. ...

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