Visual Basic® .NET by Example

SQL Primer

SQL is the language used to read and write records to many brands of relational databases including SQL Server, Oracle, Informix, etc. This chapter does not attempt to present an overview of the entire SQL language. However, you should be familiar with the basic commands if you want to understand how DataAdapters in ADO.NET actually work with a database. So to get a better understanding, the four most common SQL commands (SELECT, INSERT, UPDATE, and DELETE) are presented here.

If you plan on writing your own SQL commands directly in your code, then we assume you already have some familiarity with SQL. If you don't have this familiarity and require more information regarding SQL than what is provided in this chapter, you should purchase ...