资源描述：
《SQL-Server简介-毕业外文翻译》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。
1、外文原文IntroductiontoSQLServerBySamuelRelationaldatabaseshavebeenaroundfor30years,buttheywerenottheoriginalkindofdatabase,noraretheythenewestkindofdatabase.XMLandobject-orienteddatastructureshaveevolvedinrecentyears.Butrelationaldatabasesarestillbyfarth
2、emostpopularkindofdatabaseavailableandwillbeforsometimetocome.SQListheabbreviationofStructuredQueryLanguageanditisforrelationaldatabases,asthetitleindicatesthisisonlyforfresherwhohasjuststartedthecarrierorwhoiswaitingtoopenupthecarrierintheapplicatio
3、nprogrammingside.ButthatdoesnotmeanthisarticleisatutorialforafresherwhodoesnotknowanythingaboutSQL.ThisarticleismeantforwhoalreadyhavealittleknowledgeinSQLandwanttoimproveit.WhatDoesSQLDo?First,SQListhepremiertoolforviewinginformationfromarelationald
4、atabase.Itdoesn’tjustgiveyouadatadump.SQLgivesyousophisticatedtoolstosummarize,consolidate,andcalculatefromthedata.Usingtablerelationships,datacanbecombinedfrommultipletablesinanumberofways.Withaproperlydesigneddatabase,SQLcananswerpracticallyanyques
5、tionaboutthedata.Second,SQLprovidescommandstomanipulatethedatainarelationaldatabase.Recordscanbeupdatedandaddedtoordeletedfromatable.HereisSQLasadatabaselanguagereallyshines.Proceduralprogramminglanguages,suchasBASIC,mightrequireseverallinesofcodetou
6、pdatearecordinadatabasetable.Inaddition,proceduralprogramminglanguageswouldhavetousesomesortofloopingstructuretorepeatthisprocessoneveryrecord.SQLoperatesonanentiresetofrecordsallatthesametime.SQLislikehaikuforprogrammers;oftenadozenwordsorfewercande
7、leteorchangethousandsofrecords.Finally,SQLisacompletedatadefinitionlanguage(DDL).Thedatabaseitselfcanbecreatedalongwithalltables,fields,primarykeys,andrelationships.Addtothattherecordinsertcommands,andyoucanhaveacompletedatabaseandallitsdataexpressed
8、inprogrammingcode.Thisgreatlyenhancesadatabaseprogrammer’sabilitytoworkremotelyortoportdataenhancementsamongvariousinstallations.TheprerequisiteforlearningSQLisknowledgeinDiscreteMathematics(SetTheory,RelationsandFunctions).Althoughitisnotnecessaryto
