continued data base

Data base


SQL = structured Query Language

There are two types of data bases flat flie and relational


insert / input
Delete
update
select are used to enter or edit information.

fields are columns and records are rows in a data base table.
SQL = structured Query Language

Dim strSQLStrings() As String = {"SELECT * FROM ApprovedTravelRequests", _
"SELECT [Travel Cost] FROM ApprovedTravelRequests", _
"SELECT [Travel Cost],Location FROM ApprovedTravelRequests", _
"SELECT * FROM ApprovedTravelRequests WHERE Location = 'Richmond, VA'", _
"SELECT * FROM ApprovedTravelRequests WHERE Location LIKE 'R%'"}

"SELECT * FROM ApprovedTravelRequests WHERE Location LIKE '%R'"}
returns anything in which you chose ie letter
"SELECT * FROM ApprovedTravelRequests WHERE Location LIKE '%A%'"}
this returns anything in which the character you chose for the range or record


"SELECT * FROM ApprovedTravelRequests WHERE Location [Last Name]LIKE '%A%'"}
'[LAST NAME] square brackets used for spaces between names
these are the conditions to evaluate whether the condition is true or not

<
>
>=
<=
<>
=


"SELECT * FROM ApprovedTravelRequests WHERE [Travel Cost] = 1000 "}
To find all costs of the feilds in the table

return feilds greater than

"SELECT * FROM ApprovedTravelRequests WHERE [Travel Cost] <= 1000 "}

return feilds less than


AND

"SELECT * FROM ApprovedTravelRequests WHERE [First Name] = 'Janet' And [Last Name] = 'Dunford'"}

OR

"SELECT * FROM ApprovedTravelRequests WHERE [First Name] = 'Janet' or [Last Name] = 'Tirrel'"}
'And is the operator that looks for both names and the or looks for either name.
"SELECT * FROM ApprovedTravelRequests WHERE [Last Name] LIKE '%LAS'"}
'%LAS ANYTHING BEFORE IT OR AFTER IT wild card character


"SELECT * FROM ApprovedTravelRequests WHERE Location = 'chicago, illinois' And [Purpose for Travel] = 'Financial Seminar'", _
"SELECT * FROM ApprovedTravelRequests WHERE Location = 'chicago, illinois' OR [Purpose for Travel] = 'Financial Seminar'"}