资源描述：
《SQL server 简介-毕业论文外文翻译》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。
1、外文原文IntroductiontoSQLServerBySamuelRelationaldatabaseshavebeenaroundfor30years,buttheywerenottheoriginalkindofdatabase,noraretheythenewestkindofdatabase.XMLandobject-orienteddatastructureshaveevolvedinrecentyears.Butrelationaldatabasesarestillbyfarthemostpopularkindofdatabasea
2、vailableandwillbeforsometimetocome.SQListheabbreviationofStructuredQueryLanguageanditisforrelationaldatabases,asthetitleindicatesthisisonlyforfresherwhohasjuststartedthecarrierorwhoiswaitingtoopenupthecarrierintheapplicationprogrammingside.Butthatdoesnotmeanthisarticleisatutor
3、ialforafresherwhodoesnotknowanythingaboutSQL.ThisarticleismeantforwhoalreadyhavealittleknowledgeinSQLandwanttoimproveit.WhatDoesSQLDo?First,SQListhepremiertoolforviewinginformationfromarelationaldatabase.Itdoesn’tjustgiveyouadatadump.SQLgivesyousophisticatedtoolstosummarize,co
4、nsolidate,andcalculatefromthedata.Usingtablerelationships,datacanbecombinedfrommultipletablesinanumberofways.Withaproperlydesigneddatabase,SQLcananswerpracticallyanyquestionaboutthedata.Second,SQLprovidescommandstomanipulatethedatainarelationaldatabase.Recordscanbeupdatedandad
5、dedtoordeletedfromatable.HereisSQLasadatabaselanguagereallyshines.Proceduralprogramminglanguages,suchasBASIC,mightrequireseverallinesofcodetoupdatearecordinadatabasetable.Inaddition,proceduralprogramminglanguageswouldhavetousesomesortofloopingstructuretorepeatthisprocessonever
6、yrecord.SQLoperatesonanentiresetofrecordsallatthesametime.SQLislikehaikuforprogrammers;oftenadozenwordsorfewercandeleteorchangethousandsofrecords.Finally,SQLisacompletedatadefinitionlanguage(DDL).Thedatabaseitselfcanbecreatedalongwithalltables,fields,primarykeys,andrelationshi
7、ps.Addtothattherecordinsertcommands,andyoucanhaveacompletedatabaseandallitsdataexpressedinprogrammingcode.Thisgreatlyenhancesadatabaseprogrammer’sabilitytoworkremotelyortoportdataenhancementsamongvariousinstallations.TheprerequisiteforlearningSQLisknowledgeinDiscreteMathematic
8、s(SetTheory,RelationsandFunctions).Althoughitisnotnecessaryto
