外文翻译_--开发基于sql server 的cs数据库应用系统

A2A0A1A3A6A7A4A9A10A5A8A131A14A11A12A15开发基于SQLSERVER的C/S数据库应用系统SQLSERVER作为面向中小型企业的网络数据库服务系统，提供了与众多高级数据库管理器相同的运行性能，向传统的数据库厂商发起了强有力的挑战。在程序设计方面SQLSERVER采用了关键而新颖的对称式结构，从而简化了程序设计，并且MICROSOFT在它的VISUALBASIC可视化编程语言中为程序员提供了良好的控件；在数据库管理方面SQLSERVER以一种易于管理的方式处理多服务器事务管理，提供了一种把SQLSERVER系统扩展而超出单个计算机能力的方法。SQLSERVER主要具有以下几个功能全面的数据完整性保护，无论是复杂的事务支持和高级安全性，还是面向用户的数据库隐式部G2010，以G2462数据完整性保护G18129G17878用；与WINDOWSNTG19610G6116，G1813G16780在G54G48G51G708对称多处理G709系统中G17839行G5455G5225的多G13459程和对称多处理，并且可G19610G6116G2052G2010G5079式管理G10627G3671中；在G1314G17908G1227G5191G2500G990G1075具有G12373出性能；为系统管理员提供一G8981的管理G5049具；对多处理器G256G2010G5079式G257事务的G1881在支持。以下G1183G13473一种G5602G7691G2045用MICROSOFTSQLSERVER在WINDOWSNTSERVERG990构G12581G5332发G10627G3671，完G6116一G14336的G4470户G18服务器G5224用系统。G20G17在SQLSERVERG990G2031G5326一个数据设G3803G11在G2031G5326数据库G1055G2081G5529G20047为G16825数据库G2031G5326一个G4396G1660设G3803G12G11G20G12从MICROSOFTSQLSERVERUTILTIES程序G13464G1881G6183G5332G54G52G47G40G48。G11G21G12在SERVERMANAGERG12395G2487G18336，G17885G6333G2031G5326数据库的服务器。G3926HFNMG17。A2A0A1A3A6A7A4A9A10A5A8A132A14G11G22G12G17885G6333MANAGEG14768单G20045，G9994G2530G17885G6333G39G68G87G68G69G68G86G72G39G72G89G76G70G72G17885G20045。出G10628MANAGEDATABASEDEVICEG12395G2487。G11G23G12G17885G6333G49G72G90G39G72G89G76G70G72G6365G19074G708G12544一个G709。出G10628NEWDATABASEDEVICEG12395G2487。G11G24G12G49G68G80G72为G6164要G2031G5326的设G3803G2529；LOCATION可以G17885G6333G2031G5326设G3803的G3332G9869G708G3926G70G29G760G71G68G87G68G69G68G86G72G709；SIZEMB用于设G4462G8504设G3803的G3835小G708一G14336为数据库的G20G17G21G24G1505G709。G11G25G12单G1999CREATENOWG6365G19074，G2031G5326G8504设G3803。G8892G5859G16843在G2031G5326数据库G1055G2081G5529G20047G1820G2031G5326G1016个G4396G1660设G3803，一个是数据库的G10301理设G3803，G2490一个是数据库的G17935G17765设G3803。G21G17在SQLSERVERG990G2031G5326一个数据库G11G20G12从MICROSOFTSQLSERVERUTILTIES程序G13464G1881G6183G5332SQLEM。G11G21G12在SERVERMANAGERG12395G2487G18336，G17885G6333G2031G5326数据库的服务器。G3926HFNMG17。G11G22G12G17885G6333G48G68G81G68G74G72G14768单G20045，G9994G2530G17885G6333G39G68G87G68G69G68G86G72G17885G20045。出G10628MANAGEDATABASEG12395G2487。G11G23G12G17885G6333NEWDATABASEG6365G19074G708G12544一个G709。出G10628NEWDATABASEG12395G2487。G11G24G12G49G68G80G72G20045为数据库G2529，DATADEVICE为数据库G10301理设G3803G2529称，SIZE是G16825G10301理设G3803为数据库G2010G18209的G4396G1660G12366G19400G708G48G37G709；LOGICDEVICE为数据库G17935G17765设G3803G2529称，G54G76G93G72是G16825G17935G17765设G3803为数据库G2010G18209的G4396G1660G12366G19400G708G48G37G709。G16843G993要复G17885DEFAULTDEVICEG17885G20045。G11G25G12G6365CREATENOWG6365G19074，G8503式G2031G5326数据库。G22G17在G5062有的数据库G990G2031G5326数据G15932G11G20G12从MICROSOFTSQLSERVERUTILTIES程序G13464G1881G6183G5332SQLEM。A2A0A1A3A6A7A4A9A10A5A8A133A14G11G21G12在SERVERMANAGERG12395G2487G18336，G17885G6333服务器。单G1999G6164要G2031G5326数据G15932的数据库旁的加号。再单G1999数据库的GROUP/USERS以G2462OBJECTSG13464件。G11G22G12单G1999OBJECTSG13464件旁边的加号。SERVERMANAGER将展G5332OBJECTSG20045目，并显示出可操作的G6164有数据库对象。G11G23G12G17885G6333TABLE对象。G9994G2530单G1999MANAGERG14768单G20045，并G17885G6333TABLESG20045目。将出G10628MANAGERTABLEG11管理G15932格G12G12395G2487。G11G24G12G10628在保持TABLEG13464合框为G708G3926果在G13464合框G17885G6333了其他G15932，那么就可以修改它G709。COLUMNNAMEG29字段G2529DATATYPEG29字段类型SIZEG29字段长度NULLSG29是否G1813G16780G12366值DEFAULTG29默认值G11G25G12G6365SAVEG6365G19074，保G4396G15932格。G23G17为数据G15932G2031G5326主关键字G11G20G12启动MICROSOFTSQLSERVEREM,G17885G6333G17878当的服务器以G2462数据库。单G1999数据库旁的加号，SERVERMANAGER会展G5332数据库，并列出G6164有G13464件。G11G21G12单G1999OBJECTSG20045目旁边的加号，SERVERMANAGER会列出可操作的数据库对象。G11G22G12单G1999TABLES文件夹旁边的加号。用右键G9869G1999相G5224的数据G15932对象，G9994G2530从弹出式G14768单G18336G17885G6333EDIT命令。随G2530屏幕G990会出G10628MANAGETABLESG12395G2487。G11G23G12单G1999G5049具栏G990的ADVANCEDFEATURESG11高级特性G12G6365G19074。随G2530会出G10628与G15932格有关的更详细的信息。G11G24G12在G12544一张卡片G708PRIMARYKEY/IDENTITYG709G18336，可设置主关键字。单G1999PRIMARYA2A0A1A3A6A7A4A9A10A5A8A134A14KEYG12395框G18336的COLUMNNAMESG11列G2529G12G13464合框。会显示出未设为NULLS的一系列列G2529。G16843G17885G6333G17878当的列，使其G6116为主关键字。G11G25G12对于主关键字来说，索引类型G5224G4462义为G708NONCLUSTEREDG709。单G1999ADDG6365G19074，在G15932格G18336添加主关键字信息。G8892G5859主关键字的G4462义对于一个数据G15932来说是非常重要的，G3926果没有主关键字，那么这个数据G15932将是只读的。主关键字的G4462义G5529G20047在数据G15932保G4396G1055G2081，因为数据G15932在保G4396G2530，G6164增加的字段将G993G1813G16780为非G49UG47G47型。G24G17为G15932格G2031G5326群G19610索引G11G20G12启动SQLEM,G17885G6333相G5224的数据库。G11G21G12从MANAGEG14768单G18336G17885G6333INDEXESG17885G20045。G11G22G12在TABLEG13464合框G18336，G17885G6333G17878当的数据G15932。在INDEXG13464合框G18336，G17885G6333，以便G2031G5326一个新索引。在G18336面输入新索引的G2529字。G11G23G12在AVAILABLECOLUMNSINTABLEG11G15932格G1881的可用列G12列G15932G1881，G17885G6333G17878当的列并G6365下ADDG6365G19074。这G7691会将列G2529移至COLUMNSININDEXKEY列G15932框。还可G17885G6333多列。G11G24G12在INDEXATTRIBUTEG11索引属性G12G12395框G1881，G17885G6333CLUSTEREDG11群G19610G12复G17885框。G11G25G12在CLUSTERED旁边的G1016个单G17885G19074中，ALLOWDUPLICATEROWSG15932示G1813G16780重复行。G117G12G6365BUILDG6365G19074，G5332始G2031G5326索引。G25G17在SQLSERVER中为数据库G5332用户A2A0A1A3A6A7A4A9A10A5A8A135A14G11G20G12启动MICROSOFTSQLSERVEREM,G17885G6333G17878当的服务器。G11G21G12G17885G6333LOGIN目录，单G1999右键，G17885G6333NEWLOGING17G17G17，弹出MANAGELOGINSG12395G2487。G11G22G12在LOGINNAME中输入用户G2529；在PASSWORD中输入用户密码；在数据库框中，G17885G6333用户G6164要访问的数据库。G11G23G12单G1999G256ADD”G6365G19074。重复一次密码。7G17在SQLSERVER中为数据库用户设置访问权限G11G20G12对于新G5332的数据库一G4462要为访问它的用户提供权限，否则这个数据库是G993能被访问的。G11G21G12启动MICROSOFTSQLSERVEREM,G17885G6333G17878当的服务器以G2462数据库。G11G22G12从OBJECTG14768单中G17885G6333OBJECTPERMISSIONG14768单G20045，再在弹出的对话框中列出了单G1999BYUSER标签。G11G23G12要想授予一个用户或用户G13464特G4462的权限，只要从USER/GROUP下拉式列G15932中G17885G4462用户或用户G13464，并单G1999相G5224权限的单元格。G11G24G12最G2530单G1999G256SETG257G6365G19074，保G4396设置。G2490外，SQLSERVERG1075为系统管理员提供了功能强G3835的G3803份和恢复数据库功能。但是，想从网络G4470户机访问SQLSERVER只设服务器方还G993行。G2045用VISUALBASIC对SQLSERVERG17839行编程还需要对G4470户端的OG39G37CG17839行设置。ODBCG708G5332放数据库连接G709是MICROSOFT为G5224用程序G5332发人员提供的一种策略。它采用单一的API来辐射各种G993同的数据库引擎、关系和非关系的G39G37G48G54G708数据库管理系统G709。它使数据库G5332发人员在G5332发数据库G5224用系统的时候，可以使用G10099A2A0A1A3A6A7A4A9A10A5A8A136A14G5725的ODBCSQL语法，而G993用G13783G15397数据G9316是G1172么。G27G17以下是G4470户端ODBC的设置和G16855G16809方法G11G20G12对于USERDSN的设置在系统的G256G5332始G257G14768单G990G17885G6333G256设置G257，单G1999其中的G256控G2058面G7507G257，弹出控G2058面G7507框。G2464G1999G25632BITODBCG257G3282标，弹出G256ODBCDATASOURCEADMINISTRATORG257G12395G2487，G17885G6333G256USERDSNG257G20041，单G1999G256ADDG257G6365G19074。G313在G256CREATENEWDATASOURCEG257G12395G2487中G17885G6333G256SQLSERVERG257G2530，单G1999G256完G6116G257G6365G19074，弹出G256ODBCSQLSERVERSETUPG257G12395G2487。G314在DATASOURCENAME中输入数据G9316G2529，G3926G256PMSG257；在DESCRIPTION中输入G6563G17860信息G708可G17885G709；在SERVER中输入SQLSERVER服务器G2529，G3926G256HFSERVERG257；单G1999OPTIONG6365G19074，在DATABASENAME中输入G54G52G47G54G40G53G57G40G53数据库G2529，G3926G256PMS98G257，单G1999G256OKG257G6365G19074。G315单G1999G256G11842G4462G257G6365G19074。G11G21G12对于FILEDSN的G16855G16809在系统的G256G5332始G257G14768单G990G17885G6333G256设置G257，单G1999其中的G256控G2058面G7507G257，弹出控G2058面G7507框。G2464G1999G25632BITODBCG257G3282标，弹出G256ODBCDATASOURCEADMINISTRATORG257G12395G2487，G17885G6333G256FILEDSNG257G20041，单G1999G256ADDG17G17G257G6365G19074。G313在G256CREATENEWDATASOURCEG257G12395G2487中G17885G6333G256SQLSERVERG257G2530，单G1999G256下一G8505G257G6365G19074，在弹出的输入框中输入数据G9316G2529，G3926G256PMSG257，单G1999G256下一G8505G257G6365G19074，在弹出的信息框中单G1999G256完G6116G257G6365G19074。A2A0A1A3A6A7A4A9A10A5A8A137A14G314在弹出的SQLSERVERLOGIN对话框中在G256SERVERG257栏中输入G54G52G47G54G72G85G89G72G85服务器G2529；在G256LOGINIDG257栏和G256PASSWORDG257栏中输入G11343G19482SQLSERVER时用的用户G2529和用户G2487令；G9994G2530单G1999G256OPTIONSG257G6365G19074，在OPTIONS框中的DATABASE栏中G17885G6333G6164想G11343G19482的SQLSERVER数据库G2529。G9994G2530单G1999G256OKG257G6365G19074。VISUALBASIC50是MICROSOFTG6524出的一个功能强G3835的可视化编程G5049具。它G1985G1523与OG39G37C良好的接G2487和提供G13485用户G7509其完G2904的网络数据库访问控件，G17206G5483G3281G1881外众多编程G10245好G13785的G19750G11556。有了VISUALBASICG6117G1216可以G2045用它的OG39G37C接G2487在几G2010G19059G1881编G2058一个G3534于SQLSERVER的G4470户机G18服务器数据库G5224用G17731件。G28G17以下采用编程常用的DAO和RDOG1016种方法，为G3835G4490G1183G13473一下G5602G7691使用VISUALBASIC50访问G17840程SQLSERVER数据库G11G20G12用DAO方法G6183G5332G17840程数据库在G7424G3332ODBC的FILEDSN中设置与SQLSERVER连接的数据G9316。需要设DATASOURCENAMEG29数据G9316G2529，SERVERSQG47服务器G2529，LOGINID用户G2529，PASSWORDG29用户G2487令，DATABASENAMEG29数据库G2529。G11这种设置G993可在单机G10378G5589下设G12添加DATA控件，以G2462一个DBGRID控件G313在程序中添加G3926下G1207码G1563G4462数据G9316G2529为PMSG30用户G2529为TEST；用户G2487令为G22G24G24；SQLSERVER数据G15932为G5049G17176G5785G1929。DIMSSQLASSTRINGDATA1CONNECTODBCDSNPMSUIDTESTPWD355SSQLSELECTFROMG5049G17176G5785G1929G261DATA1RECORDSOURCESSQLA2A0A1A3A6A7A4A9A10A5A8A138A14DATAREFRESHG314运行程序G2375可。G11G21G12用RDO方法G6183G5332G17840程数据库在G7424G3332ODBC的USERDSN中设置与SQLSERVER连接的数据G9316。需要设DATASOURCENAMEG29数据G9316G2529，DESCRPTIONG29G6563G17860，SERVERSQLSERVER服务器G2529，DATABASENAMEG29数据库G2529。G11这种设置可在单机G10378G5589下设G12在程序中添加OPTIONEXPLICITPRIVATEMRDOENVASRDOENVIRONMENTPRIVATEMRDOCONNASRDOCONNECTIONPRIVATEMRDORSASRDORESULTSETPRIVATESUBCOMMAND1CLICKDIMSSQLASSTRINGSETMRDOENVRDOENVIRONMENTS0SETMRDOCONNMRDOENVOPENCONNECTIONPMS,RDDRIVERNOPROMPT,FALSE,ODBCUIDTESTPWD355SSQLSELECTFROMG5049G17176G5785G1929G261SETMRDORSMRDOCONNOPENRESULTSETSSQL,RDOPENKEYSET,RDCONCURROWVER,0出处G999G4490系统与G5224用,G227G2379,G28G7388份发行G28G2052G21G19G20G19G5192,G20041G25G23G27G21G16G25G23G28G21A2A0A1A3A6A7A4A9A10A5A8A139A14A16A12A17A12A15SOURCEEXPERTSYSTEMSWITHAPPLICATIONSVOLUME37ISSUE9SEPTEMBER2010PAGES64826492DEVELOPMENTBASEDONSQLSERVERC/SDATABASEAPPLICATIONSYSTEMSQLTHESERVERACHIEVEMENTFACETHESMALLANDMEDIUMSIZEDENTERPRISETHENETWORKDATABASESERVICESYSTEM,HASPROVIDEDWITHTHEMULTITUDINOUSHIGHLEVELDATABANKADMINISTRATIONSAMEPERFORMANCECHARACTERISTIC,INITIATEDTHEPOWERFULCHALLENGETOTHETRADITIONALDATABASEMERCHANTINPROGRAMMINGASPECTSQLSERVERHASUSEDTHEKEYBUTTHENOVELSYMMETRICALEXPRESSIONSTRUCTURE,THUSSIMPLIFIEDTHEPROGRAMMING,ANDMICROSOFTVISIBLEPROGRAMMINGLANGUAGEPROVIDEDGOODINITSVISUALINTHEBASICFORTHEPROGRAMMERHASCONTROLLEDINDATABANKADMINISTRATIONASPECTSQLSERVERTHEWAYWHICHEASYTOMANAGEBYONEKINDPROCESSESTHEMULTISERVERSBUSINESSMANAGEMENT,PROVIDEDONEKINDSYSTEMTOEXPANDSQLTHESERVERSURPASSESTHESINGLECOMPUTERCAPACITYTHEMETHODSQLSERVERMAINLYHASFOLLOWINGSEVERALFUNCTIONSCOMPREHENSIVEDATAINTEGRITYPROTECTION,REGARDLESSOFISTHECOMPLEXBUSINESSSUPPORTANDTHEHIGHLEVELSECURITY,ORHIDESTHETYPEFACEUSERSDATABASETOBEPARTIAL,ASWELLASTHEDATAINTEGRITYPROTECTIONALLISSUITABLEWITHWINDOWSTHENTINTEGRATION,ALLOWSINSMPSYMMETRICALMULTIPROCESSINGINTHESYSTEMTOCARRYONTHETHOROUGHMULTITHREADINGANDTHESYMMETRICALMULTIPROCESSING,ANDMAYINTEGRATEINTHEDISTRIBUTIONALMANAGEMENTENVIRONMENTALSOHASTHEPROMINENTPERFORMANCEINTHELOWCONSTRUCTIONCOSTPLATFORMPROVIDESTHEFIRSTCLASSMANAGEMENTTOOLFORTHESYSTEMMANAGERTOMULTIPROCESSOR“DISTRIBUTIONAL“BUSINESSINTRINSICSUPPORTBELOWINTRODUCEDHOWONEKINDDOESUSEMICROSOFTSQLSERVERTOCONSTRUCTTHEDEVELOPMENTENVIRONMENTONWINDOWSNTSERVER,COMPLETESTHEGENERALCUSTOMER/SERVERAPPLICATIONSYSTEMA18A19A20A21A22A23A24A25A26A27A28A2910A30ONFOUNDSADATAEQUIPMENTINSQLSERVERINFRONTOFFOUNDATIONDATABASEMUSTFORTHISDATABASEFOUNDASTORAGEDEVICEPROCEDUREGROUPOPENSSQLEMFROMMICROSOFTSQLSERVERINUTILTIESINSERVERINMANAGERWINDOW,CHOICEFOUNDATIONDATABASESERVERIFHFNMCHOOSESTHEMANAGEVEGETABLESINGLEITEM,THENCHOOSESDATABASETHEDEVICEOPTIONAPPEARSMANAGEDATABASETHEDEVICEWINDOWCHOOSESNEWTHEDEVICEBUTTONFIRSTAPPEARSNEWDATABASETHEDEVICEWINDOWNAMEFOREQUIPMENTWHICHMUSTFOUNDLOCATIONMAYCHOOSEFOUNDSTHEEQUIPMENTTHEPLACEFOREXAMPLECDATABASESIZEMBUSESINTOESTABLISHTHISEQUIPMENTTHESIZEGENERALLYFORDATABASE125TIMESSINGLECLICKSCREATETHENOWBUTTON,FOUNDSTHISEQUIPMENTATTENTIONPLEASEINFRONTOFFOUNDATIONDATABASEMUSTFIRSTFOUNDTWOSTORAGEDEVICES,ISTHEDATABASEPHYSICALEQUIPMENT,ANOTHERISTHEDATABASELOGICALEQUIPMENT2ONFOUNDSADATABASEINSQLSERVER1PROCEDUREGROUPTOOPENSQLEMFROMMICROSOFTSQLSERVERINUTILTIES2INSERVERINMANAGERWINDOW,CHOICEFOUNDATIONDATABASESERVER3CHOOSESTHEMANAGEVEGETABLESINGLEITEM,THENCHOOSESTHEDATABASEOPTIONAPPEARSMANAGETHEDATABASEWINDOW4CHOOSESNEWTHEDATABASEBUTTONFIRSTAPPEARSNEWTHEDATABASEWINDOW5THENAMEITEMFORDATABASE,DATADEVICEISTHEDATABASEPHYSICSEQUIPMENTNAME,SIZEISTHISPHYSICALEQUIPMENTFORTHEDATABASEASSIGNMENTSTORAGESPACEMBLOGICDEVICEISTHEDATABASELOGICEQUIPMENTNAME,SIZEISTHISLOGICALEQUIPMENTFORTHEDATABASEASSIGNMENTSTORAGESPACEMBPLEASEDOESNOTWANTREELECTIONDEFAULTTHEDEVICEOPTION6ACCORDINGTOCREATETHENOWBUTTON,OFFICIALLYFOUNDSTHEDATABASE3INTHEDATABASEWHICHHASFOUNDEDTHEDATASHEET1PROCEDUREGROUPTOOPENSQLEMFROMMICROSOFTSQLSERVERINUTILTIES2INSERVERINTHEMANAGERWINDOW,CHOOSESTHESERVERSINGLECLICKSMUSTFOUNDTHEDATASHEETNEARBYTHEDATABASEPLUSSIGNAGAINSINGLECLICKSTHEDATABASEGROUP/USERSASWELLASTHEOBJECTSMODULEA31A32A33A34A35A36A37A38A26A27A28A2911A303SINGLECLICKSNEARBYTHEOBJECTSMODULETHEPLUSSIGNSERVERMANAGERWILLLAUNCHTHEOBJECTSPROJECT,ANDDEMONSTRATEDMIGHTOPERATEALLDATABASESOBJECT4CHOOSESTHETABLEOBJECTTHENSINGLECLICKSTHEMANAGERVEGETABLESINGLEITEM,ANDCHOOSESTHETABLESPROJECTWILLAPPEARMANAGERTABLEMANAGEMENTFORMTHEWINDOW5THEPRESENTMAINTAINSTHETABLECOMBINATIONFRAMEFORIFWERECOMBININGFRAMETOCHOOSEOTHERTABLES,THENWASALLOWEDTOREVISEITCOLUMNNAMEFIELDNAMEDATATYPEFIELDTYPESIZEFIELDLENGTHNULLSWHETHERPERMITSSPATIALVALUEDEFAULTTACITLYAPPROVESTHEVALUE6ACCORDINGTOTHESAVEBUTTON,PRESERVESTHEFORM4FOUNDSTHEHOSTESSENTIALCHARACTERFORTHEDATASHEET1TOSTARTMICROSOFTSQLSERVEREM,CHOOSESTHESUITABLESERVERASWELLASTHEDATABASESINGLECLICKSNEARBYTHEDATABASETHEPLUSSIGN,SERVERMANAGERCANLAUNCHTHEDATABASE,JUXTAPOSESALLMODULES2SINGLECLICKSNEARBYTHEOBJECTSPROJECTTHEPLUSSIGN,SERVERMANAGERCANLISTTHEDATABASEOBJECTWHICHMAYOPERATE3SINGLECLICKSNEARBYTHETABLESFOLDERTHEPLUSSIGNCLICKSONTHECORRESPONDINGDATASHEETOBJECTWITHTHERIGHTKEY,THENFROMSPRINGSINTHETYPEMENUTOCHOOSETHEEDITORDERAFTERWARDSONTHESCREENCANAPPEARMANAGETHETABLESWINDOW4SINGLECLICKSONTHETOOLFENCEADVANCEDFEATURESHIGHLEVELCHARACTERISTICTHEBUTTONAFTERWARDSCANAPPEARWITHTHEFORMRELATEDMOREDETAILEDINFORMATION5INTHEFIRSTCARDPRIMARYKEY/IDENTITYIN,MAYSUPPOSETHEBUYERESSENTIALCHARACTERSINGLECLICKSINPRIMARYKEYWINDOWFRAMECOLUMNNAMESAROWNAMETOCOMBINETHEFRAMECANDEMONSTRATEHASNOTSUPPOSEDISTHENULLSASERIESOFROWSNAMEPLEASECHOOSETHESUITABLEROW,CAUSESITTOBECOMEPRIMARILYTHEESSENTIALCHARACTER6SAIDREGARDINGTHEHOSTESSENTIALCHARACTERTHAT,THEINDEXTYPESHOULDDEFINEASNONCLUSTEREDSINGLECLICKSTHEADDBUTTON,INCREASESTHEHOSTESSENTIALCHARACTERINFORMATIONINTHEFORMATTENTIONHOSTESSENTIALCHARACTERDEFINITIONREGARDINGADATASHEETSAIDISCOUNTFORMUCH,IFHASA31A32A33A34A35A36A37A38A26A27A28A2912A30NOTADVOCATEDTHEESSENTIALCHARACTER,THENTHISDATASHEETWILLBEREADONLYBHOSTESSENTIALCHARACTERDEFINITIONMUSTBEFORETHEDATASHEETPRESERVATION,BECAUSETHEDATASHEETAFTERTHEPRESERVATION,INCREASESTHEFIELDWILLNOTPERMITFORNONNULL5GATHERSINGREATNUMBERTHEINDEXFORTHEFORMFOUNDATION1TOSTARTSQLEM,CHOOSESTHECORRESPONDINGDATABASE2CHOOSESTHEINDEXESOPTIONFROMTHEMANAGEMENU3INTHETABLECOMBINATIONFRAME,CHOOSESTHESUITABLEDATASHEETININDEXCOMBINATIONFRAME,CHOICE,INORDERTOFOUNDSARECENTINDEXINPUTSTHERECENTINDEXININSIDETHENAMEIN4INFORMMAYUSEROWINAVAILABLECOLUMNSINTABLETOTABULATE,CHOOSESTHESUITABLEROWANDPRESSESDOWNTHEADDBUTTONTHISCANARRANGEINORDERTHENAMETOMOVETOCOLUMNSININDEXKEYTABULATESTHEFRAMEALSOMAYCHOOSETHEMULTIROWS5ININDEXATTRIBUTEINDEXATTRIBUTEINTHEWINDOWFRAME,CHOOSESCLUSTEREDTOGATHERINGREATNUMBERTHEREELECTIONFRAME6INCLUSTEREDTWOSHANXUANNIU,ALLOWDUPLICATEROWSEXPRESSIONPERMISSIONREPETITIONLINE7ACCORDINGTOTHEBUILDBUTTON,STARTSTOFOUNDTHEINDEX6OPENSTHEUSERINSQLSERVERFORTHEDATABASE1TOSTARTMICROSOFTSQLSERVEREM,CHOOSESTHESUITABLESERVER2CHOOSESTHELOGINTABLEOFCONTENTS,SINGLECLICKSTHERIGHTKEY,CHOOSESNEWLOGINSPRINGSMANAGETHELOGINSWINDOW3INPUTSUSERINLOGINNAMEINPUTSTHEUSERPASSWORDINPASSWORDINTHEDATABASEFRAME,CHOOSESTHEDATABASEWHICHTHEUSERMUSTVISIT4SINGLECLICKS“ADD“THEBUTTONDUPLICATESATIMEOFPASSWORD7INSQLSERVERFORDATABASEUSERESTABLISHMENTVISITJURISDICTION1CERTAINLYMUSTFORVISITITSUSERINSQLSERVERFORTHEDATABASEUSERESTABLISHMENTVISITJURISDICTIONREGARDINGTHENEWLYOPENEDDATABASETOPROVIDETHEJURISDICTION,OTHERWISETHISDATABASEISCANNOTVISITA31A32A33A34A35A36A37A38A26A27A28A2913A302STARTSMICROSOFTSQLSERVEREM,CHOOSESTHESUITABLESERVERASWELLASTHEDATABASE3CHOOSESOBJECTFROMTHEOBJECTMENUTHEPERMISSIONVEGETABLESINGLEITEM,AGAININSPRINGSINTHEDIALOGBOXLISTEDHASSINGLECLICKEDBYUSTHELABEL4MUSTWANTTOAWARDAUSERORTHEUSERGROUPSPECIFICJURISDICTION,SOLONGASPULLSTHETYPEFROMUSER/GROUPTOTABULATEDESIGNATEDTHEUSERORTHEUSERGROUP,ANDSINGLECLICKSTHECORRESPONDINGJURISDICTIONTHEUNITSTANDARD5FINALLYSINGLECLICKS“SET“THEBUTTON,PRESERVESTHEESTABLISHMENTMOREOVER,SQLSERVERHASALSOPROVIDEDTHEFUNCTIONFORMIDABLEBACKUPFORTHESYSTEMMANAGERANDRESTORESTHEDATABASEFUNCTIONBUT,WANTSTOVISITSQLSERVERFROMTHENETWORKCLIENTONLYTOSUPPOSETHESERVERSIDENOTTOBEGOODCARRIESONTHEPROGRAMMINGUSINGVISUALBASICTOSQLSERVERALSOTONEEDTOCARRYONTHEESTABLISHMENTTOCUSTOMERENDODBCODBCOPENINGDATABASECONNECTIONISMICROSOFTISONEKINDOFSTRATEGYWHICHTHEAPPLICATIONPROCEDUREDEVELOPMENTPERSONNELPROVIDESITUSESSOLEAPITORADIATEEACHKINDOFDIFFERENTDATABASEENGINE,RELATIONALANDNONRELATIONALDBMSDATABASEMANAGEMENTSYSTEMITCAUSESTHEDATABASEDEVELOPMENTPERSONNELATDEVELOPMENTDATABASEAPPLICATIONSYSTEMTIME,MAYUSEFAMILIARODBCTHESQLGRAMMAR,BUTDOESNOTUSETHECONSIDERATIONDATAPOOLISANY8BELOWISTHECUSTOMERCARRIESODBCTHEESTABLISHMENTANDTHEDEBUGGINGMETHOD1REGARDINGTHEUSERDSNESTABLISHMENT1“THESTART“INTHEMENUCHOOSES“THEESTABLISHMENT“INTHESYSTEM,SINGLECLICKS“THECONTROLPANEL“,SPRINGSTHECONTROLPANELFRAME2DOUBLECLICKS“32BITODBC“THECHARTSIGN,SPRINGS“ODBCDATASOURCEADMINISTRATOR“THEWINDOW,THECHOICE“USERDSN“THEPAGE,SINGLECLICKS“ADD“BUTTON3INTHEWINDOWCHOOSES“SQLSERVER“AFTER“CREATENEWDATASOURCE“,SINGLECLICKS“COMPLETES“THEBUTTON,SPRINGS“ODBCSQLSERVERSETUP“THEWINDOW4INPUTSDATASOURCENAMEINDATASOURCENAME,LIKE“PMS“INPUTSTHEDESCRIPTIONA31A32A33A34A35A36A37A38A26A27A28A2914A30INFORMATIONINDESCRIPTIONTOBEPOSSIBLETOELECTINPUTSSQLINSERVERSERVERSERVER,LIKE“HFSERVER“SINGLECLICKSTHEOPTIONBUTTON,INPUTSSQLINDATABASENAMESERVERDATABASE,IF“PMS98“,SINGLECLICKS“OK“THEBUTTON5SINGLECLICKS“DETERMINES“THEBUTTON2REGARDINGFILEDSNDEBUGGING1“THESTART“INTHEMENUCHOOSES“THEESTABLISHMENT“REGARDINGTHEFILEDSNDEBUGGINGINTHESYSTEM,SINGLECLICKS“THECONTROLPANEL“,SPRINGSTHECONTROLPANELFRAME