SQL Server databases inotsigira pamatafura kuchengetedza deta. Muchidzidzo ichi, tichaongorora nzira yekugadzirisa nekushandisa tafura yezvinyorwa muMicrosoft SQL Server.
Nhanho yekutanga yekushandura tafura ye SQL Server inosarudzwa kwete yemazuva ano. Gara pasi ne pensi uye pepa uye shandisa mufananidzo we database yako. Iwe unoda kuve nechokwadi kuti unosanganisira minda yakakodzera yezvinodiwa zvebhizimisi rako uye sarudza yakakodzera deta dzemhando kuti ubatisise data yako.
Iva nechokwadi chekuziva nezvekugadzirisa zvigadziridzo zvemasitoriki zvigadziriswa zvisati zvaitika mushure mokunge uumba matafura muMicrosoft SQL Server.
01 of 06
Tanga SQL Server Management Studio
Vhura Microsoft SQL Server Management Studio (SSMS) uye uone kuseri kwaunoda kuwedzera tafura itsva.
02 of 06
Wedzera Tafura yeTables yeDhipatimendi Yakakodzera
Kana ukangoshamwaridzana neSQL Server yakarurama, wedzera Databases folder uye sarudza database iyo iwe unoda kuwedzera tafura itsva. Wedzera iyo faira yepa database uye wozowedzera Tables pasi.
03 of 06
Tanga Tafura Mugadziri
Kungofa-kanda paTables subfolder uye sarudza Itafura Itafura sarudzo. Izvi zvichatanga SQL Server's graphical Table Designer, sezvaratidzwa mumufananidzo uri pamusoro.
04 of 06
Wedzera Columns kuTetara Rako
Iye zvino yava nguva yekuwedzera mapuranga awakagadzirirwa muchikamu chekutanga 1. Tanga nekukanda muchitsauko chekutanga chisingabatsiri pasi pezita reKumbora rinotungamirirwa muTable Designer.
Kana wati wapinda zita rakakodzera, sarudza rudzi rwemhando kubva kubhokisi rebhokisi pasi munharaunda inotevera. Kana uri kushandisa dhiyabhorosi iyo inobvumira kureba kwakasiyana, iwe unogona kutsanangura urefu chaiyo nekuchinja kukosha kunoonekwa muvabereki vekutevera zvichienderana nezita remhando yezita.
Kana iwe uchida kubvumira NULL maitiro mumutsetse uyu, chengeta "Rega Nulls".
Dzokorora urongwa uhwu kusvikira wawedzera mapuranga ose anodiwa kutafura yako yeSQL Server detafura.
05 of 06
Sarudza Chinyorwa Chekutanga
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) ichava nechiratidzo chikuru, sekuratidzwa mumufananidzo uri pamusoro.
Kana iwe uchida rubatsiro, dzidza kuti ungasarudza sei chinhu chikuru .
06 of 06
Chengeta Tafura Yenyu Itsva
Usakanganwa kuchengeta tafura yako! Paunonyanya kuvhara muponesi icon yekutanga, iwe uchabvunzwa kupa zita rakasiyana nedzimba retafura yako.