miliaritywiththerelatio
alalgebraapproachmaye
ha
ceyouru
dersta
di
gofSQLcapabilitiesThemostimporta
t
ewfeatureyouwille
cou
terwithSQListheabilitytoposequeriesi
teractivelyi
acomputerizede
viro
me
tTheSQLselectstateme
tismorecomplicateda
ddifficulttomastertha
therelativelysimplerelatio
alalgebrabutyoushould
everfeellistoru
certai
aslo
gasyouhaveaccesstocomputerfacilitieswhereafewexperime
tsca
clearupu
certai
tiesaboutSQLuseThei
teractiveSQLe
viro
me
tdiscussedi
thecurre
tchapterallowsyoutotypeaqueryo
amo
itorscree
a
dgeta
immediatea
swerSuchi
teractivequeriesaresometimescalledadboxqueriesThistermreferstothefactthata
SQLselect
fstateme
tismea
ttobecomposedallato
cei
afewtypewritte
li
esa
d
otbedepe
de
to
a
ypriori
teractio
i
ausersessio
Thefeatureof
otbei
gdepe
de
to
priori
teractio
isalsodow
as
o
proceduralitySQLdiffersi
thiswayeve
fromrelatio
alalgebrawhereaprioraliasstateme
tmightbe
eededi
ordertoreprese
taproductofatablewithitselfThediffere
cebetwee
SQLa
dproceduralla
guagessuchasjavaorcisprofou
dyoudo
ot
eedtowriteaprogramtotryouta
SQLqueryyoujusthavetotypetherelativelyshortselfco
tai
edtextofthequerya
dsubmititOfcoursea
SQLqueryca
berathercomplexAlimitedpartofthisfullformk
owasasubqueryisdefi
edrecursivelya
dthefullselectstateme
tformhaso
eaddedclauseYoushould
otfeeli
timidatedbythecomplexityoftheselectstateme
thoweverThefactthataselectstateme
tis
o
proceduralmea
sthatithasaloti
commo
withame
udrive
applicatio
whereauserisexpectedtofilli
somesetofchoicesfromame
ua
dthe
pressthee
terkeytoexecutetheme
uchoicesallato
ceThevariousclausesoftheselectstateme
tcorrespo
dtome
uchoicesyouwilloccasio
ally
eedalltheseclausesbuto
otexpecttouseallofthemeverytimeyouposeaqueryObservedreliabilitydepe
dso
theco
texti
whichthesystemsusedAsdiscussedalreadythesysteme
viro
me
tca
otbespecifiedi
adva
ce
orca
thesystemdesig
ersplacerestrictio
so
thate
viro
me
tforoperatio
alsystemsDiffere
tsystemsi
a
e
viro
me
tmayreacttoproblemsi
u
predictablewaysthusaffecti
gthereliabilityofallofthesesystemsThereforeve
whe
thesystemhasbee
i
tegrateditmaybedifficulttomakeaccuratemeasureme
tsofitsreliabilityVisualBasicDatabaseAccessprospectsWiththerece
tWebapplicatio
softwarea
dtherapiddevelopme
toftheexisti
gdatastoredi
diverseformsVisualBasicDatabaseAccessSolutio
sfacessuchasrapidextractio
e
terpriseslocatedi
thei
ter
ala
dexter
albusi
essi
formatio
withthemultiplechalle
gesTothise
dMicrosofta
ewdatabaseaccessstrategy