Ulwazi lwe-SQL Server luthembele kumatafula ukugcina idatha. Kulesi sifundo, sizohlola inqubo yokuklama nokusebenzisa ithebula lemininingwane ku-Microsoft SQL Server.
Isinyathelo sokuqala sokusebenzisa ithebula le-SQL Server sinqunyelwe ukuthi akuyona ezobuchwepheshe. Hlala phansi ngepensela nephepha bese udweba umklamo we-database yakho. Uzofuna ukuqinisekisa ukuthi ufaka amasimu afanele ezidingo zebhizinisi lakho bese ukhetha izinhlobo ezifanele zedatha ukuze ubambe idatha yakho.
Qinisekisa ukuthi uyazi kahle izinto ezisisekelo zokugcina idatha ngaphambi kokuba uhlele ekudaleni amatafula ku-Microsoft SQL Server.
01 ka-06
Qala SQL Server Management Studio
Vula i-Microsoft SQL Server Management Studio (SSMS) bese uxhuma kuseva lapho ungathanda ukwengeza itafula elisha.
02 ka 06
Nweba ifolda yamatafula kuDatha elifanelekile
Uma usuxhumekile ku-SQL Server efanele, yandisa ifolda yolwazi bese ukhetha database lapho ungathanda ukwengeza itafula elisha. Nweba ifolda ye-database bese wandisa i-Tables subfolder.
03 ka 06
Qala umklami weThebula
Chofoza ngakwesokudla kwi-Tables subfolder bese ukhetha inketho entsha yeThebula. Lokhu kuzoqala umdwebi weThebula we-SQL Server, njengoba kuboniswe esithombeni ngenhla.
04 ka 06
Engeza amakholomu kuThebula Lakho
Manje sekuyisikhathi sokungeza amakholomu owawakhiwe esitegeni 1. Qala ngokuchofoza esitokisini sokuqala esingenalutho ngaphansi kwegama lekholomu elibheke kuDesign Designer.
Uma usufakile igama elifanele, khetha uhlobo lwedatha kusuka ebhokisini lokudonsa ekolini elilandelayo. Uma usebenzisa uhlobo lwedatha evumela ubude obuhlukile, ungacacisa ubude obuqondile ngokushintsha inani elivela kubazali abathintekayo ngemuva kwegama lomsebenzisi wedatha.
Uma ungathanda ukuvumela amanani we-NULL kule kholomu, chofoza u- "Vumela ama-Nulls".
Phinda le nqubo uze wengeze wonke amakholomu adingekayo kuthebula lakho le-SQL Server database.
05 ka 06
Khetha ukhiye oyinhloko
Okulandelayo, qokomisa ikholomu (ama) oyikhethile ukhiye oyinhloko wetafula lakho. Bese uchofoza isithonjana esikhiye kubha yomsebenzi ukusetha ukhiye oyinhloko. Uma unekhibhodi eyisisekelo eningi, sebenzisa ukhiye we-CTRL ukugqamisa imigqa eminingi ngaphambi kokuchofoza isithonjana esikhiye.
Uma usuwenzile lokhu, ikholomu eyinhloko yokhiye izoba nophawu oluyinhloko, njengoba kuboniswe esithombeni esingenhla.
Uma udinga usizo, funda indlela yokukhetha ukhiye oyinhloko .
06 ka-06
Londoloza ithebula lakho elisha
Ungakhohlwa ukulondoloza ithebula lakho! Uma uchofoza ukulondoloza isithonjana okokuqala, uzocelwa ukuba unikeze igama eliyingqayizivele letafula lakho.