Mauthenga a SQL Server akudalira pa matebulo kusunga deta. Mu phunziro ili, tidzafufuza momwe polojekiti ikuyendera ndikugwiritsira ntchito tebulo lachinsinsi mu Microsoft SQL Server.
Gawo loyamba la kukwaniritsa tebulo la SQL Server limasankhidwa osati luso. Khala pansi ndi pensulo ndi pepala ndikuwonetseratu mapangidwe anu. Mufuna kuonetsetsa kuti mukuphatikizapo zofunikira pa bizinesi lanu ndikusankha mtundu wolondola wa deta kuti mutenge deta yanu.
Onetsetsani kuti mudziwe bwino zofunikira zenizeni zapamwamba musanayambe kupanga ma tebulo mu Microsoft SQL Server.
01 ya 06
Yambani SQL Server Management Studio
Tsegulani Microsoft SQL Server Management Studio (SSMS) ndi kulumikiza ku seva kumene mukufuna kuwonjezera tebulo latsopano.
02 a 06
Lonjezani Foda ya Masamba ku Database Yoyenera
Mukangogwirizana ndi SQL Server yoyenera, yonjezerani foda yanuyi ndikusankha deta yomwe mungakonde kuwonjezera tebulo latsopano. Lonjezerani fayilo yachinsinsiyi ndikuwonjezerani ma tebulo.
03 a 06
Yambani Wokonza Mapu
Dinani pamanja pazithunzi zazithunzi ndikusankha Zatsopano Zam'mbuyo. Izi zimayambitsa SQL Server's Tableal Designer, monga momwe tawonetsera pa chithunzi pamwambapa.
04 ya 06
Onjezani Ma Columns ku Gome Lanu
Tsopano ndi nthawi yowonjezera zipilala zomwe mudapanga pachithunzi 1. Yambani mwa kuwonekera mu selo loyamba lopanda kanthu pansi pa Dzina la Phukusi lolowera mu Zamagetsi.
Mukangoyamba kutchula dzina loyenera, sankhani mtundu wa deta kuchokera m'bokosi lotsika pansi pazotsatira. Ngati mukugwiritsa ntchito deta yomwe imalola kutalika kwake, mukhoza kutanthauzira kutalika kwake mwa kusintha mtengo umene umawoneka m'mabaibulo pambuyo pa dzina la deta.
Ngati mukufuna kulola ziphuphu za NULL m'mbali iyi, dinani "Lolani Nulls".
Bwerezani njirayi mpaka mutapangira mazenera onse oyenera pa tebulo lanu lachinsinsi la SQL Server.
05 ya 06
Sankhani Chinsinsi Chachikulu
Kenaka, tchulani ndime (s) zomwe mwasankha pachinsinsi chachikulu cha tebulo lanu. Kenaka dinani chizindikiro chachinsinsi mu taskbar kuti muike chinsinsi chachikulu. Ngati muli ndi fungulo lofunika kwambiri, gwiritsani ntchito CTRL key kuti muike mizere yambiri musanatsegule chithunzi.
Mukachita izi, mndandanda wachinsinsi (key) uli ndi chizindikiro chofunikira, monga momwe chikuwonetsedwera pamwambapa.
Ngati mukufuna thandizo, phunzirani momwe mungasankhire kiyi yoyamba .
06 ya 06
Sungani Gome Lanu Latsopano
Musaiwale kusunga tebulo lanu! Mukasintha chizindikiro chosungira kwa nthawi yoyamba, mudzafunsidwa kupereka dzina lapadera la tebulo lanu.