Iidable zikhonza njengeyunithi yenyaniso yoncedo kuyo nayiphi na idatha, kuquka abo balawulwa yi- SQL Server 2012 . Ukuyila iitafile ezifanelekileyo ukugcina idatha yakho yimbopheleleko ebalulekileyo yomqhubi wesiseko sedatha kwaye bobabini abaqulunqi kunye nabalawuli kufuneka baqhelane nenkqubo yokudala iileta ezintsha zeenkcukacha zeSQL Server. Kule nqaku, sihlolisisa inkqubo ngokubanzi.
Qaphela ukuba eli nqaku lichaza inkqubo yokudala amatafula kuMicrosoft SQL Server 2012. Ukuba usebenzisa inguqu eyahlukileyo yeS Server Server, nceda funda Ukudala iiTables kwi-Microsoft SQL Server 2008 okanye Ukudala iifayile kwi-Microsoft SQL Server 2014.
Inyathelo 1: Yenza iThebula lakho
Ngaphambi kokuba ucinge malunga nokuhlala kwibhodibhodi, susa ithuluzi elibaluleke kakhulu eliyilungiselelo elitholakalayo kunoma yiphina umthuthukisi wesiseko-ipencil nephepha. (Kulungile, uvunyelwe ukusebenzisa ikhompyutheni ukwenjenjalo ukuba uyathanda - iMicrosoft Visio inikeza ezinye iikhotlathi ezicwangcisiweyo.)
Thatha ixesha lokukhangela uyilo lwe database yakho ukuze ludibanise zonke iinkcukacha zeenkcukacha kunye nolwalamano oluya kulufuna ukuhlangabezana neemfuno zakho zoshishino. Uya kuba ngcono xa uqala inkqubo ngenkqubo eqinile ngaphambi kokuba uqale ukudala amatafula. Njengoko udibanisa isiseko sakho seenkcukacha, qiniseka ukuba ufake i- database yolwazi ukukhokela umsebenzi wakho.
Inyathelo 2: Qala i-Studio ye-SQL Server Management Studio
Emva kokuba wenze i-database yakho, ixesha lokuba uqalise ukuphunyezwa kwangempela. Indlela elula yokwenza oku kukusebenzisa iSquL Server Management Studio. Hamba uye uvule iiSMS kwaye udibanise kumncedisi ogcina indawo yolwazi apho ungathanda ukudala itafile entsha.
Inyathelo lesi-3: Hlela kwiFolda echanekileyo
Kwi-SSMS, kuya kufuneka uhambe ngokuya kwiifayile zeeTables zeenkcukacha ezichanekileyo. Qaphela ukuba isakhiwo sefolda kwicala lasekhohlo le window liqulethe ifolda ebizwa ngokuba yi "Databases". Qala ngokukhulisa le folda. Emva koko uza kubona iifolda ezihambelana noluhlu lweenkcukacha ezigcinwe kwiseva yakho. Ukwandisa ifolda ehambelana nedatha apho ufuna ukudala itafile entsha.
Ekugqibeleni, wandise iTables kwifolda phantsi kwesi saziso. Thatha isikhashana uhlolisise uluhlu lweetafile ezikhoyo kwiziko ledatha kwaye qinisekisa ukuba zibonisa ukuqonda kwakho kwisakhiwo sesiseko sekhoyo. Ufuna ukuqiniseka ukuba awuyi kudala itafile ephindwe kabini, njengoko oku kuya kubangela iingxaki ezibalulekileyo phantsi kwendlela engenokuba nzima ukuyilungisa.
Inyathelo 4: Qala Ukudala Itafile
Ukucofa ngakwesokudla kwiifayili zeTables uze ukhethe Ithebula elitsha kwimenyu ephumayo. Oku kuza kuvula uluhlu olutsha kwi-SSMS apho ungakha itafile yakho yokuqala yedatha.
Inyathelo lesi-5: Yenza iikholam zeTable
I-interface yolungiselelo ikunikezela ngegridi emithathu yekholam ukucacisa izakhiwo zeetafile. Ngomxholo ngamnye ofuna ukuwugcina etafileni, kuya kufuneka uchonge:
- Igama lekholomu : Oku, ngokucacileyo, negama lesibonakaliso. Isalathisi ngasinye sesicatshulwa sifana nesitshintshi; yinto enye yedatha ukuba i-database yakho igcine irekhodi nganye. Umzekelo, ukuba unetafile equlethwe ngolwazi lokuqhagamshelana, unokufumana iikholomu ezibizwa ngokuba ngu-FirstName, LastName, HomePhone, kunye ne-imeyileI-imeyile eneenkcukacha malunga nomntu ngamnye kwisiseko soqhagamshelwano.
- Uluhlu Lwedatha : Uhlobo lwedatha lubonisa uhlobo lolwazi oza kugcina kwikholam nganye. Ngokomzekelo, igama lokuqala lomntu liqukethe umtya weetekisi, ngoko ungasebenzisa uhlobo lwedatha ye - varchar (50) ukubonisa ukuba ikholomu iya kuba nekhowudi yobude obungaguqukiyo engabalinganiswa no-50. Ngokufanayo, umhla wokuzalwa uza kusebenzisa uhlobo lomhla wolwazi. Ukufumana ulwazi oluthe vetshe, jonga inqaku lethu kwiindidi zeenkcukacha zeSQL Server.
- Vumela i-Nulls : Le nto nje ibhokisi yokukhangela. Ukuba uyitshekisha, i-database izakuvumela ukuba ugcine ubunqunu obungenanto (okanye obungenanto) kuloo kholomu. Ukufumana ulwazi oluthe vetshe, jonga ukuqonda amaxabiso e-NULL .
Hamba uye uzalise i-matrix yegridi, unikezele nganye nganye yeenkcukacha ezintathu kwiikholomu kwitheyibhile yakho entsha yedatha.
Inyathelo 6: Ukuchonga isiCwangciso sePrayimari
Emva koko, gxi ninisa iikholam (ezi) ezikhethiweyo kwikhiye weprayimari yakho . Emva koko nqakraza iqhosha eliphambili kwibar yomsebenzi ukusetha ikona ephambili. Ukuba unesitshixo esisisiseko se-intanethi, sebenzisa ukhiye weCTRL ukugqamisa imigqa emininzi ngaphambi kokucofa i icon.
Emva kokuba wenze oku, iikholomu eziphambili eziphambili ziya kubonisa uphawu olubalulekileyo ngakwesobunxele kwigama lekholomu, njengoko kuboniswe kumfanekiso ongentla. Ukuba ufuna uncedo, unokufuna ukufunda isihloko ekukhethiweyo .
Inyathelo lesi-7: Igama kunye nokugcina iThebula lakho
Emva kokudala ikona ephambili, sebenzisa isithonjana sediski kwibar yamathuluzi ukugcina itafile yakho kumncedisi. Uyacelwa ukuba unikeze igama lakho kwitafile xa uyilondoloza okokuqala. Qiniseka ukuba ukhethe into echazayo eya kunceda abanye baqonde injongo yetafile.
Kukho konke okukuyo. Ndiyakuvuyela ekudaleni itafile yakho yokuqala yeSQL Server!