Tables inoshanda sechinhu chikuru chesangano kune chero dheseti, kusanganisira avo vanotungamirirwa neSQL Server 2012 . Kugadzira matafura akakodzera kuti uchengetedze data yako ibasa rinokosha rekugadzira zvinyorwa zvemasvomhu uye vose vanogadzira uye vatungamiri vanofanira kuziva nezvekugadzira hurongwa hutsva hweSquL Server database. Muchikamu chino, tinoongorora tsanangudzo yacho zvakadzama.
Cherechedza kuti chinyorwa chino chinotsanangura nzira yekuumba matafura muMicrosoft SQL Server 2012. Kana uri kushandisa shanduro yakasiyana ye SQL Server, tapota verenga Kuumba Tables mu Microsoft SQL Server 2008 kana Kuumba Tables mu Microsoft SQL Server 2014.
Danho 1: Gadzira Tafura Yako
Iwe usati wafunga nezvekugara pabhobhobhoti, bvisa kunze kwekukosha kwekugadzira chigadzirwa chiripo kune chero nyanzvi yekugadzira zvinyorwa-peni nepapepa. (Hungu, unobvumirwa kushandisa kombiyuta kuti uite izvi kana uchida - Microsoft Visio inopa mamwe mazano ekugadzirisa.)
Tora nguva yekufananidza zvigadzirwa zve database yako kuitira kuti inosanganisira zvose zvezvinhu zvehutano uye hukama hwaunoda kusangana nebhizimisi rako zvido. Iwe uchange uri nani pane imwe nguva kana iwe ukatanga nzira yacho nehutano hwakasimba usati watanga kugadzira tafura. Sezvo iwe uchigadzira dhesi yako, iva nechokwadi chokuti unosanganisira dhizha rekuchengetedzwa kwemashoko kutungamirira basa rako.
Danho 2: Tanga SQL Server Management Studio
Kana ukangodaro wakagadzira database yako, inguva yekutanga kushandiswa kwechokwadi. Nzira iri nyore kuita izvi ndeyokushandisa SQL Server Management Studio. Enda mberi uye usvinudze SSMS uye uende kune sevha iyo inoshandisa database iyo iwe unoda kugadzira tafura itsva.
Danho 3: Enda kune Firiji Yakarurama
MuchiSMSMS, iwe unofanirwa kuenderera kuTables faira ye database yakarurama. Cherechedza kuti faira yakagadzirirwa kuruboshwe rworwindo ine faira inonzi "Databases". Tanga nekuwedzera iyi folda. Iwe uchazoona mahwendefa anowirirana neumwe wezvinyorwa zvakagoverwa pane yako seva. Wedzera faira inowirirana ne database uko unoshuva kugadzira tafura itsva.
Pakupedzisira, wedzera maTables folder pasi peyo database. Tora nguva kuti uongorore mazita ematafura anenge atove mu database uye ave nechokwadi kuti inoratidza kunzwisisa kwako kwechirongwa chekodhidhiyo chiripo. Iwe unoda kuve nechokwadi kuti usati waumba patafura, sezvo izvi zvichange zvichikukonzera matambudziko makuru mumugwagwa unogona kunge wakaoma kugadzirisa.
Danho 4: Tanga Tafura Yokusika
Kumanikodha paTables faira uye sarudza Tafura Idzva kubva pane-pop-up menu. Izvi zvichazarura pane zvitsva mukati meSMSMS apo unogona kugadzira tafura yako yekutanga ye database.
Danho 5: Ita Tafura Yematombo
Izvo zvinogadzirwa zvinokupa iwe ine goridhi gurati rechitatu kuti ujekese tafura yezvinhu. Pamusoro pehumwe humwe unhu hwaunoda kuzvichengeta patafura, iwe uchada kuziva:
- Zita Rokutanga : Izvi, chaizvoizvo, zita rechiito. Chinhu chimwe nechimwe chezvinyorwa zvemashoko chakafanana nechachinjwa; icho chinhu chimwe chete chezvinhu data iyo database yako ichachengetedza rimwe rekodhi. Semuenzaniso, kana iwe une tafura yakazara nemashoko ekukurukurirana, unogona kuva nemakomboti ainzi FirstName, LastName, HomePhone, uye ImeyiliAddress ine zveruzhinji pamusoro pemunhu wese mu database.
- Data Dhiyabhorosi : Inonzi data inotsanangura rudzi rwehuwandu hwauchazochengeta mumutsetse mumwe nomumwe. Semuenzaniso, zita rekutanga romunhu rine rwonzi rwemashoko, saka unogona kushandisa varchar (50) rudzi rwemhando kuti uratidze kuti chinyorwa chichava nesimbi yakakura yakasiyana-siyana isingasviki makumi mashanu. Saizvozvowo, zuva rekuberekwa raizoshandisa zuva rekutsvaga dhiyabhorosi. Kuti uwane mamwe mashoko, ona nyaya yedu pane SQL Server data types.
- Rega Nulls : Izvi zvinongova cheki chekuongorora. Kana iwe uchitarisa, database yacho ichakubvumira kuti uchengetedze nhamba dzisina (kana kuti dzisina kukwana) muhomwe iyoyo. Kuti uwane mamwe mashoko, ona Kunzwisisa NULL Values .
Enda mberi uye upedze matrix grid, uchipa imwe neimwe yezvikamu zvitatu zvemashoko kune imwe koromo mufurafura yako itsva ye database.
Danho 6: Ziva Chinokosha Chinokosha
Zvadaro, sarudzai chinyorwa (s) chawakasarudza pikisi yako yekutanga yefurafura. Zvadaro, chengetedza maikorodhe ekudhinda mubhari rebasa kuti uise chinangwa chekutanga. Kana iwe une kiyi yakakosha yakakosha, shandisa CTRL key kuti uise mitsetse yakawanda usati wavhara ikoni icon.
Kana uchinge waita izvi, nheyo huru yekoni (s) icharatidza chiratidzo chikuru kune kuruboshwe rwezita remutemo, sezvinoratidzwa mumufananidzo uri pamusoro. Kana iwe uchida rubatsiro, ungada kuverenga iyo nyaya Kusarudza Chinyorwa Chekutanga .
Danho 7: Zita uye Chengeta Tafura Yako
Mushure mekugadzira kiyi yekutanga, shandisa i disk icon mubhari rekushandisa kuchengetedza tafura yako kune sevha. Iwe uchabvunzwa kupa zita retafura yako kana iwe uchiichengeta kwekutanga. Iva nechokwadi chekusarudza chimwe chinhu chinotsanangura chichabatsira vamwe kunzwisisa chinangwa chetafura.
Ndizvo zvose zviripo kune iyo. Congratulations pakusika yako yekutanga SQL Server tafura!