Welcome / Home
Understanding My PC
Software Downloads
VB.NET
JAVA
C#.NET
RPG
SQL
Software Engineering
Networking
Communications
Security
Internet Links
Contact Us

Structured Query Language
 

Stuctured Query Language (SQL) is a univerally accepted  language used to communicate with database server engines.

SQL was developed by IBM and has standards committees that control its syntax.

SQL is used to interactivly work with databases or can be embedded in most computer languages to control database requests.

 



SQL Insert
  The SQL Insert Statement is used to add a record to a database table. There are two basic ways to code an Insert statement. The first is where one populates the data by passing only the data and allowing the database engine to fill each field in the order that the data is passed. The second method passes both the field names and the data thus specifying what field gets which piece of data. The second method is preferred because a change in the data table schema will not mandate a change in coding.

SQL Update
  The SQL Update statement does what it is named for. It is used to update fields within a record or across multiple records. An Update statement is coded to specfiy which fields are to be updated. Any field not targeted for update will remain unchanged.

SQL Delete
  The SQL Delete Statement is used to delete a record or more than one record as specificed by a WHERE clause. A deleted record in most databases is not really deleted but usually flagged for deletion at the next packing command.

SQL Select
  Using the SQL Select Statement

SQL Aggregates
  Using the SQL Aggregate Functions

SQL Joins
  Using the SQL Select Join Statements

SQL Embedded
  Using the SQL Embedded Select Statements

SQL Unions
  Using the SQL Select Union Statements




|Welcome / Home| |Understanding My PC| |Software Downloads| |VB.NET| |JAVA| |C#.NET| |RPG| |SQL| |Software Engineering| |Networking| |Communications| |Security| |Internet Links| |Contact Us|