I-SQL Server yolwazi ixhomekeke kwiithebula ukugcina idatha. Kule tutorial, siza kuhlola inkqubo yokuyila nokufeza itafile yedatha kwi-Microsoft SQL Server.
Isinyathelo sokuqala sokuphunyezwa kwetafile ye-SQL Server sinqunywe ngokungekho yobugcisa. Hlala phantsi nge pensile kunye nephepha uze udwebe uyilo lovimba bakho. Uzakufuna ukuqinisekisa ukuba ufake iindawo ezifanelekileyo kwiimfuno zoshishino lakho kwaye ukhethe iinkcukacha ezichanekileyo zokugcina idatha yakho.
Qinisekisa ukuba uqhelanise nezinto ezisisiseko zokugcina iinkcukacha ngaphambi kokuba uhlalutye ekwakheni amatafula kwi-Microsoft SQL Server.
01 ngo-06
Qala i-Studio yeSquL yeService Studio
Vula iMicrosoft SQL Server Management Studio (SSMS) kwaye uqhagamshele kwiseva apho ungathanda ukufaka itafile entsha.
02 we-06
Ukwandisa iTables Folder kwiDatabase efanelekileyo
Emva kokuba uxhumeke kwiSQL Server yangakwesokudla, wandise ifolda yolwazi kwaye ukhethe idatha apho ungathanda ukufaka itafile entsha. Ukwandisa ifolda yeenkcukacha ze-database uze wandise iTables subfolder.
03 we-06
Qala uMyili weThebula
Nqakraza ngakwesokudla kwiiDeskliphu zefayile uze ukhethe ikhefu entsha yeTable. Oku kuya kuqalisa iS Designer Designer ye-SQL Server, njengoko kuboniswe kumfanekiso ongentla.
04 we-06
Yongeza iikholomu kwiThebula lakho
Ngoku lixesha lokuongeza iikholomu ozidibeneyo kwisinyathelo 1. Qala ngokuchofoza kwisitayile esingenanto esingaphantsi phantsi kwegama lekholomu elibhekise kwi-Table Designer.
Emva kokuba ungene igama elifanelekileyo, khetha uhlobo lweedatha ukusuka kwibhokisi ehlayo kwicala elilandelayo. Ukuba usebenzisa uhlobo lwedatha oluvumela ubude obuhlukeneyo, ungacacisa ubude obuchanekileyo ngokutshintsha ixabiso elivela kubazali babazali ngokulandela igama lohlobo lweedatha.
Ukuba ungathanda ukuvumela ixabiso le-NULL kule kholam, nqakraza "Vumela i-Nulls".
Phinda le nkqubo uze udibanise zonke iikholomu eziyimfuneko kwitafile yakho yesiseko seSQL Server.
05 ka 06
Khetha iSisiseko esiPrayimari
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.
Xa usenzile oku, iikholam yeprayimari eziphambili ziya kuba neesimboli esibalulekileyo, njengoko kuboniswe kumfanekiso ongentla.
Ukuba ufuna uncedo, funda indlela yokukhetha ikona ephambili .
06 we-06
Gcina iThebula lakho elitsha
Ungalibali ukugcina itafile yakho! Xa uqakraza ukugcina uphawu lwexesha lokuqala, uya kucelwa ukuba unikeze igama elikhethekileyo kwitheyibhile yakho.