In this chapter, I’ll describe how to run SQL programs in these DBMSes:
Microsoft Access 2002
Microsoft SQL Server 2000
Microsoft Access’s graphical interface lets you run only one SQL statement at a time; to run multiple SQL statements, embed them in a Visual Basic program (not covered in this book). The other DBMSes let you run SQL programs in interactive mode or script mode. In interactive mode, you type individual SQL statements at a command prompt and view the results of each statement separately, so input and output are interleaved. In script mode (also called batch mode), you save your entire SQL program in a text file (called a script or a batch file), and a command-line utility takes ...