SQL statements are used by Access, ADO, Oracle, Informix, and not suprisingly, MS SQL server. In short, if you use databases, be it in VB, ASP, FoxPro, Access or anything else, at some stage you will need to know SQL. SQL, or Structured Query Language gives you complete control over databases, creating, deleting, modifying, adding, reading, sorting, querying and much more beside.
In this tutorial, we will cover the basic statements letting you request, add, modify and delete records, which are the commands you are most likely to use.
*** If you are using VB, ASP or Access, you can use the Execute method of a Connection object to run a SQL command ***
Comments