A2A0A1A3A6A7A4A9A10A5A8A131A14A11A12A15開發(fā)基于SQLSERVER的C/S數(shù)據(jù)庫應(yīng)用系統(tǒng)SQLSERVER作為面向中小型企業(yè)的網(wǎng)絡(luò)數(shù)據(jù)庫服務(wù)系統(tǒng)，提供了與眾多高級數(shù)據(jù)庫管理器相同的運行性能，向傳統(tǒng)的數(shù)據(jù)庫廠商發(fā)起了強有力的挑戰(zhàn)。在程序設(shè)計方面SQLSERVER采用了關(guān)鍵而新穎的對稱式結(jié)構(gòu)，從而簡化了程序設(shè)計，并且MICROSOFT在它的VISUALBASIC可視化編程語言中為程序員提供了良好的控件；在數(shù)據(jù)庫管理方面SQLSERVER以一種易于管理的方式處理多服務(wù)器事務(wù)管理，提供了一種把SQLSERVER系統(tǒng)擴展而超出單個計算機能力的方法。SQLSERVER主要具有以下幾個功能全面的數(shù)據(jù)完整性保護，無論是復雜的事務(wù)支持和高級安全性，還是面向用戶的數(shù)據(jù)庫隱式部G2010，以G2462數(shù)據(jù)完整性保護G18129G17878用；與WINDOWSNTG19610G6116，G1813G16780在G54G48G51G708對稱多處理G709系統(tǒng)中G17839行G5455G5225的多G13459程和對稱多處理，并且可G19610G6116G2052G2010G5079式管理G10627G3671中；在G1314G17908G1227G5191G2500G990G1075具有G12373出性能；為系統(tǒng)管理員提供一G8981的管理G5049具；對多處理器G256G2010G5079式G257事務(wù)的G1881在支持。以下G1183G13473一種G5602G7691G2045用MICROSOFTSQLSERVER在WINDOWSNTSERVERG990構(gòu)G12581G5332發(fā)G10627G3671，完G6116一G14336的G4470戶G18服務(wù)器G5224用系統(tǒng)。G20G17在SQLSERVERG990G2031G5326一個數(shù)據(jù)設(shè)G3803G11在G2031G5326數(shù)據(jù)庫G1055G2081G5529G20047為G16825數(shù)據(jù)庫G2031G5326一個G4396G1660設(shè)G3803G12G11G20G12從MICROSOFTSQLSERVERUTILTIES程序G13464G1881G6183G5332G54G52G47G40G48。G11G21G12在SERVERMANAGERG12395G2487G18336，G17885G6333G2031G5326數(shù)據(jù)庫的服務(wù)器。G3926HFNMG17。A2A0A1A3A6A7A4A9A10A5A8A132A14G11G22G12G17885G6333MANAGEG14768單G20045，G9994G2530G17885G6333G39G68G87G68G69G68G86G72G39G72G89G76G70G72G17885G20045。出G10628MANAGEDATABASEDEVICEG12395G2487。G11G23G12G17885G6333G49G72G90G39G72G89G76G70G72G6365G19074G708G12544一個G709。出G10628NEWDATABASEDEVICEG12395G2487。G11G24G12G49G68G80G72為G6164要G2031G5326的設(shè)G3803G2529；LOCATION可以G17885G6333G2031G5326設(shè)G3803的G3332G9869G708G3926G70G29G760G71G68G87G68G69G68G86G72G709；SIZEMB用于設(shè)G4462G8504設(shè)G3803的G3835小G708一G14336為數(shù)據(jù)庫的G20G17G21G24G1505G709。G11G25G12單G1999CREATENOWG6365G19074，G2031G5326G8504設(shè)G3803。G8892G5859G16843在G2031G5326數(shù)據(jù)庫G1055G2081G5529G20047G1820G2031G5326G1016個G4396G1660設(shè)G3803，一個是數(shù)據(jù)庫的G10301理設(shè)G3803，G2490一個是數(shù)據(jù)庫的G17935G17765設(shè)G3803。G21G17在SQLSERVERG990G2031G5326一個數(shù)據(jù)庫G11G20G12從MICROSOFTSQLSERVERUTILTIES程序G13464G1881G6183G5332SQLEM。G11G21G12在SERVERMANAGERG12395G2487G18336，G17885G6333G2031G5326數(shù)據(jù)庫的服務(wù)器。G3926HFNMG17。G11G22G12G17885G6333G48G68G81G68G74G72G14768單G20045，G9994G2530G17885G6333G39G68G87G68G69G68G86G72G17885G20045。出G10628MANAGEDATABASEG12395G2487。G11G23G12G17885G6333NEWDATABASEG6365G19074G708G12544一個G709。出G10628NEWDATABASEG12395G2487。G11G24G12G49G68G80G72G20045為數(shù)據(jù)庫G2529，DATADEVICE為數(shù)據(jù)庫G10301理設(shè)G3803G2529稱，SIZE是G16825G10301理設(shè)G3803為數(shù)據(jù)庫G2010G18209的G4396G1660G12366G19400G708G48G37G709；LOGICDEVICE為數(shù)據(jù)庫G17935G17765設(shè)G3803G2529稱，G54G76G93G72是G16825G17935G17765設(shè)G3803為數(shù)據(jù)庫G2010G18209的G4396G1660G12366G19400G708G48G37G709。G16843G993要復G17885DEFAULTDEVICEG17885G20045。G11G25G12G6365CREATENOWG6365G19074，G8503式G2031G5326數(shù)據(jù)庫。G22G17在G5062有的數(shù)據(jù)庫G990G2031G5326數(shù)據(jù)G15932G11G20G12從MICROSOFTSQLSERVERUTILTIES程序G13464G1881G6183G5332SQLEM。A2A0A1A3A6A7A4A9A10A5A8A133A14G11G21G12在SERVERMANAGERG12395G2487G18336，G17885G6333服務(wù)器。單G1999G6164要G2031G5326數(shù)據(jù)G15932的數(shù)據(jù)庫旁的加號。再單G1999數(shù)據(jù)庫的GROUP/USERS以G2462OBJECTSG13464件。G11G22G12單G1999OBJECTSG13464件旁邊的加號。SERVERMANAGER將展G5332OBJECTSG20045目，并顯示出可操作的G6164有數(shù)據(jù)庫對象。G11G23G12G17885G6333TABLE對象。G9994G2530單G1999MANAGERG14768單G20045，并G17885G6333TABLESG20045目。將出G10628MANAGERTABLEG11管理G15932格G12G12395G2487。G11G24G12G10628在保持TABLEG13464合框為G708G3926果在G13464合框G17885G6333了其他G15932，那么就可以修改它G709。COLUMNNAMEG29字段G2529DATATYPEG29字段類型SIZEG29字段長度NULLSG29是否G1813G16780G12366值DEFAULTG29默認值G11G25G12G6365SAVEG6365G19074，保G4396G15932格。G23G17為數(shù)據(jù)G15932G2031G5326主關(guān)鍵字G11G20G12啟動MICROSOFTSQLSERVEREM,G17885G6333G17878當?shù)姆?wù)器以G2462數(shù)據(jù)庫。單G1999數(shù)據(jù)庫旁的加號，SERVERMANAGER會展G5332數(shù)據(jù)庫，并列出G6164有G13464件。G11G21G12單G1999OBJECTSG20045目旁邊的加號，SERVERMANAGER會列出可操作的數(shù)據(jù)庫對象。G11G22G12單G1999TABLES文件夾旁邊的加號。用右鍵G9869G1999相G5224的數(shù)據(jù)G15932對象，G9994G2530從彈出式G14768單G18336G17885G6333EDIT命令。隨G2530屏幕G990會出G10628MANAGETABLESG12395G2487。G11G23G12單G1999G5049具欄G990的ADVANCEDFEATURESG11高級特性G12G6365G19074。隨G2530會出G10628與G15932格有關(guān)的更詳細的信息。G11G24G12在G12544一張卡片G708PRIMARYKEY/IDENTITYG709G18336，可設(shè)置主關(guān)鍵字。單G1999PRIMARYA2A0A1A3A6A7A4A9A10A5A8A134A14KEYG12395框G18336的COLUMNNAMESG11列G2529G12G13464合框。會顯示出未設(shè)為NULLS的一系列列G2529。G16843G17885G6333G17878當?shù)牧?，使其G6116為主關(guān)鍵字。G11G25G12對于主關(guān)鍵字來說，索引類型G5224G4462義為G708NONCLUSTEREDG709。單G1999ADDG6365G19074，在G15932格G18336添加主關(guān)鍵字信息。G8892G5859主關(guān)鍵字的G4462義對于一個數(shù)據(jù)G15932來說是非常重要的，G3926果沒有主關(guān)鍵字，那么這個數(shù)據(jù)G15932將是只讀的。主關(guān)鍵字的G4462義G5529G20047在數(shù)據(jù)G15932保G4396G1055G2081，因為數(shù)據(jù)G15932在保G4396G2530，G6164增加的字段將G993G1813G16780為非G49UG47G47型。G24G17為G15932格G2031G5326群G19610索引G11G20G12啟動SQLEM,G17885G6333相G5224的數(shù)據(jù)庫。G11G21G12從MANAGEG14768單G18336G17885G6333INDEXESG17885G20045。G11G22G12在TABLEG13464合框G18336，G17885G6333G17878當?shù)臄?shù)據(jù)G15932。在INDEXG13464合框G18336，G17885G6333，以便G2031G5326一個新索引。在G18336面輸入新索引的G2529字。G11G23G12在AVAILABLECOLUMNSINTABLEG11G15932格G1881的可用列G12列G15932G1881，G17885G6333G17878當?shù)牧胁6365下ADDG6365G19074。這G7691會將列G2529移至COLUMNSININDEXKEY列G15932框。還可G17885G6333多列。G11G24G12在INDEXATTRIBUTEG11索引屬性G12G12395框G1881，G17885G6333CLUSTEREDG11群G19610G12復G17885框。G11G25G12在CLUSTERED旁邊的G1016個單G17885G19074中，ALLOWDUPLICATEROWSG15932示G1813G16780重復行。G117G12G6365BUILDG6365G19074，G5332始G2031G5326索引。G25G17在SQLSERVER中為數(shù)據(jù)庫G5332用戶A2A0A1A3A6A7A4A9A10A5A8A135A14G11G20G12啟動MICROSOFTSQLSERVEREM,G17885G6333G17878當?shù)姆?wù)器。G11G21G12G17885G6333LOGIN目錄，單G1999右鍵，G17885G6333NEWLOGING17G17G17，彈出MANAGELOGINSG12395G2487。G11G22G12在LOGINNAME中輸入用戶G2529；在PASSWORD中輸入用戶密碼；在數(shù)據(jù)庫框中，G17885G6333用戶G6164要訪問的數(shù)據(jù)庫。G11G23G12單G1999G256ADD”G6365G19074。重復一次密碼。7G17在SQLSERVER中為數(shù)據(jù)庫用戶設(shè)置訪問權(quán)限G11G20G12對于新G5332的數(shù)據(jù)庫一G4462要為訪問它的用戶提供權(quán)限，否則這個數(shù)據(jù)庫是G993能被訪問的。G11G21G12啟動MICROSOFTSQLSERVEREM,G17885G6333G17878當?shù)姆?wù)器以G2462數(shù)據(jù)庫。G11G22G12從OBJECTG14768單中G17885G6333OBJECTPERMISSIONG14768單G20045，再在彈出的對話框中列出了單G1999BYUSER標簽。G11G23G12要想授予一個用戶或用戶G13464特G4462的權(quán)限，只要從USER/GROUP下拉式列G15932中G17885G4462用戶或用戶G13464，并單G1999相G5224權(quán)限的單元格。G11G24G12最G2530單G1999G256SETG257G6365G19074，保G4396設(shè)置。G2490外，SQLSERVERG1075為系統(tǒng)管理員提供了功能強G3835的G3803份和恢復數(shù)據(jù)庫功能。但是，想從網(wǎng)絡(luò)G4470戶機訪問SQLSERVER只設(shè)服務(wù)器方還G993行。G2045用VISUALBASIC對SQLSERVERG17839行編程還需要對G4470戶端的OG39G37CG17839行設(shè)置。ODBCG708G5332放數(shù)據(jù)庫連接G709是MICROSOFT為G5224用程序G5332發(fā)人員提供的一種策略。它采用單一的API來輻射各種G993同的數(shù)據(jù)庫引擎、關(guān)系和非關(guān)系的G39G37G48G54G708數(shù)據(jù)庫管理系統(tǒng)G709。它使數(shù)據(jù)庫G5332發(fā)人員在G5332發(fā)數(shù)據(jù)庫G5224用系統(tǒng)的時候，可以使用G10099A2A0A1A3A6A7A4A9A10A5A8A136A14G5725的ODBCSQL語法，而G993用G13783G15397數(shù)據(jù)G9316是G1172么。G27G17以下是G4470戶端ODBC的設(shè)置和G16855G16809方法G11G20G12對于USERDSN的設(shè)置在系統(tǒng)的G256G5332始G257G14768單G990G17885G6333G256設(shè)置G257，單G1999其中的G256控G2058面G7507G257，彈出控G2058面G7507框。G2464G1999G25632BITODBCG257G3282標，彈出G256ODBCDATASOURCEADMINISTRATORG257G12395G2487，G17885G6333G256USERDSNG257G20041，單G1999G256ADDG257G6365G19074。G313在G256CREATENEWDATASOURCEG257G12395G2487中G17885G6333G256SQLSERVERG257G2530，單G1999G256完G6116G257G6365G19074，彈出G256ODBCSQLSERVERSETUPG257G12395G2487。G314在DATASOURCENAME中輸入數(shù)據(jù)G9316G2529，G3926G256PMSG257；在DESCRIPTION中輸入G6563G17860信息G708可G17885G709；在SERVER中輸入SQLSERVER服務(wù)器G2529，G3926G256HFSERVERG257；單G1999OPTIONG6365G19074，在DATABASENAME中輸入G54G52G47G54G40G53G57G40G53數(shù)據(jù)庫G2529，G3926G256PMS98G257，單G1999G256OKG257G6365G19074。G315單G1999G256G11842G4462G257G6365G19074。G11G21G12對于FILEDSN的G16855G16809在系統(tǒng)的G256G5332始G257G14768單G990G17885G6333G256設(shè)置G257，單G1999其中的G256控G2058面G7507G257，彈出控G2058面G7507框。G2464G1999G25632BITODBCG257G3282標，彈出G256ODBCDATASOURCEADMINISTRATORG257G12395G2487，G17885G6333G256FILEDSNG257G20041，單G1999G256ADDG17G17G257G6365G19074。G313在G256CREATENEWDATASOURCEG257G12395G2487中G17885G6333G256SQLSERVERG257G2530，單G1999G256下一G8505G257G6365G19074，在彈出的輸入框中輸入數(shù)據(jù)G9316G2529，G3926G256PMSG257，單G1999G256下一G8505G257G6365G19074，在彈出的信息框中單G1999G256完G6116G257G6365G19074。A2A0A1A3A6A7A4A9A10A5A8A137A14G314在彈出的SQLSERVERLOGIN對話框中在G256SERVERG257欄中輸入G54G52G47G54G72G85G89G72G85服務(wù)器G2529；在G256LOGINIDG257欄和G256PASSWORDG257欄中輸入G11343G19482SQLSERVER時用的用戶G2529和用戶G2487令；G9994G2530單G1999G256OPTIONSG257G6365G19074，在OPTIONS框中的DATABASE欄中G17885G6333G6164想G11343G19482的SQLSERVER數(shù)據(jù)庫G2529。G9994G2530單G1999G256OKG257G6365G19074。VISUALBASIC50是MICROSOFTG6524出的一個功能強G3835的可視化編程G5049具。它G1985G1523與OG39G37C良好的接G2487和提供G13485用戶G7509其完G2904的網(wǎng)絡(luò)數(shù)據(jù)庫訪問控件，G17206G5483G3281G1881外眾多編程G10245好G13785的G19750G11556。有了VISUALBASICG6117G1216可以G2045用它的OG39G37C接G2487在幾G2010G19059G1881編G2058一個G3534于SQLSERVER的G4470戶機G18服務(wù)器數(shù)據(jù)庫G5224用G17731件。G28G17以下采用編程常用的DAO和RDOG1016種方法，為G3835G4490G1183G13473一下G5602G7691使用VISUALBASIC50訪問G17840程SQLSERVER數(shù)據(jù)庫G11G20G12用DAO方法G6183G5332G17840程數(shù)據(jù)庫在G7424G3332ODBC的FILEDSN中設(shè)置與SQLSERVER連接的數(shù)據(jù)G9316。需要設(shè)DATASOURCENAMEG29數(shù)據(jù)G9316G2529，SERVERSQG47服務(wù)器G2529，LOGINID用戶G2529，PASSWORDG29用戶G2487令，DATABASENAMEG29數(shù)據(jù)庫G2529。G11這種設(shè)置G993可在單機G10378G5589下設(shè)G12添加DATA控件，以G2462一個DBGRID控件G313在程序中添加G3926下G1207碼G1563G4462數(shù)據(jù)G9316G2529為PMSG30用戶G2529為TEST；用戶G2487令為G22G24G24；SQLSERVER數(shù)據(jù)G15932為G5049G17176G5785G1929。DIMSSQLASSTRINGDATA1CONNECTODBCDSNPMSUIDTESTPWD355SSQLSELECTFROMG5049G17176G5785G1929G261DATA1RECORDSOURCESSQLA2A0A1A3A6A7A4A9A10A5A8A138A14DATAREFRESHG314運行程序G2375可。G11G21G12用RDO方法G6183G5332G17840程數(shù)據(jù)庫在G7424G3332ODBC的USERDSN中設(shè)置與SQLSERVER連接的數(shù)據(jù)G9316。需要設(shè)DATASOURCENAMEG29數(shù)據(jù)G9316G2529，DESCRPTIONG29G6563G17860，SERVERSQLSERVER服務(wù)器G2529，DATABASENAMEG29數(shù)據(jù)庫G2529。G11這種設(shè)置可在單機G10378G5589下設(shè)G12在程序中添加OPTIONEXPLICITPRIVATEMRDOENVASRDOENVIRONMENTPRIVATEMRDOCONNASRDOCONNECTIONPRIVATEMRDORSASRDORESULTSETPRIVATESUBCOMMAND1CLICKDIMSSQLASSTRINGSETMRDOENVRDOENVIRONMENTS0SETMRDOCONNMRDOENVOPENCONNECTIONPMS,RDDRIVERNOPROMPT,FALSE,ODBCUIDTESTPWD355SSQLSELECTFROMG5049G17176G5785G1929G261SETMRDORSMRDOCONNOPENRESULTSETSSQL,RDOPENKEYSET,RDCONCURROWVER,0出處G999G4490系統(tǒng)與G5224用,G227G2379,G28G7388份發(fā)行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