Microsoft SQL Server DBMS yog ib qho ntawm qhov muaj zog tshaj plaws thiab feem ntau cov kev daws teeb meem ntawm cov niaj hnub SQL servers pabcuam kev cuam tshuam databases. Feem ntau ntawm Microsoft SQL Server database cov ntaub ntawv khaws tseg yog mdf (Master Database File) cov ntaub ntawv. Xws li cov ntaub ntawv tuaj yeem raug saib los ntawm kev xa lawv mus rau tus neeg rau zaub mov khiav.
Tsim nyog
- - nruab thiab khiav Microsoft SQL Server rau ntawm lub tshuab ua hauv zos;
- - ntsia daim ntawv thov SQL Server Management Studio.
Cov Lus Qhia
Kauj ruam 1
Txuas rau SQL Server. Yog tias SQL Server Management Studio twb tau khiav tas lawm, xaiv File thiab Txuas Lus Tshawb Fawb… los ntawm cov ntawv qhia zaub mov. Daim Ntawv Txuas Rau Server nkag yuav tshwm. Tsis tas li, qhov kev sib tham no tau tshwm sim tam sim ntawd tom qab pib thov.
Nyob rau hauv Server yam nco-down nyob hauv Daim Ntawv Txuas Rau Server, xaiv Database Engine. Nyob rau hauv lub Server npe teb, sau lub npe ntawm koj lub khoos phis tawm. Xaiv hom kev lees paub los ntawm Daim Ntawv Teev Cov Neeg Txom Nyem. Yog tias koj xaiv SQL Server Authentication, nkag mus rau koj lub npe neeg rau zaub mov hauv tus neeg siv lub npe thiab Tus password. Nyem Rau Txuas Txuas khawm.
Kauj ruam 2
Pib txheej txheem ntawm kev mus ua cov ntaub ntawv. Hauv qhov Object Explorer pane, muaj txoj nyem rau ntawm cov khoom Database. Hauv cov ntawv qhia zaub mov, xaiv cov khoom "Txuas …".
Kauj ruam 3
Qhia kom meej mdf cov ntaub ntawv ntawm cov chaw khaws ntaub ntawv, cov ntsiab lus uas koj xav pom. Hauv kab ntawv muab tso nrog Cov Ntaub Ntawv Txuas ntawm lub qhov rais, nyem rau ntawm "Ntxiv …" khawm. Qhov Chaw Teev Cov Ntaub Ntawv Cov Ntaub Ntawv yuav tshwm sim. Hauv Xaiv qhov ntawv cov ntoo ntoo ntawm cov lus sib tham no, nrhiav thiab nthuav tawm cov ntawm sib phim rau cov ntawv sau npe uas cov phiaj xwm cov ntaub ntawv nyob. Thauv xim ntawv. Nyem OK.
Kauj ruam 4
Ntxiv cov ntaub ntawv rau lub server. Hauv Daim Ntawv Rau Cov Ntaub Ntawv Database nyob rau hauv, hauv Databases kom xa cov npe, xaiv cov khoom sib thooj rau mdf ntawv sau tseg rau hauv kauj ruam dhau los. Saib xyuas cov ntsiab lus ntawm Cov Ntawv Teev Cov Ntawv Teev Npe. Yog tias nws muaj cov khoom uas nws daim teb muaj cov ntawv tsis pom, rub tawm. Ua kom zoo li no, xaiv cov ntsiab nrog nas thiab nias lub khawm Tshem tawm. Cov khoom zoo sib xws tau ntxiv rau cov ntaub ntawv teev tsis muaj log. Nyem OK.
Kauj ruam 5
Tshawb xyuas tus qauv ntawm cov ntaub ntawv hauv cov ntawv mdf. Nthuav cov Databases node nyob hauv Object Explorer pane. Nthuav cov nkees sib haum rau cov ntaub ntawv sau ua ntej. Saib cov ntsiab lus ntawm nws cov nodes. Piv txwv li, Cov Kab Ntawv Ntxhuav muaj cov khoom sib xws rau cov ntxhuav database, ntu Views muaj mappings, thiab ntu Programmability muaj tag nrho cov haujlwm, hom, cov txheej txheem khaws cia, thiab tshwm sim hauv cov ncauj lus.
Kauj Ruam 6
Saib cov ntsiab lus ntawm cov khoom siv database tshwj xeeb hauv cov ntawv mdf. Hauv qhov Object Explorer pane, xaiv lub ntsiab lus txaus siab (piv txwv li, lub rooj lossis cov zaub) thiab nyem nws sab xis. Hauv cov ntawv qhia zaub mov, xaiv cov khoom pib nrog lo lus Qhib (piv txwv li Qhib Rooj lossis Qhib Saib) kom pom thiab txhim kho cov ntaub ntawv, lossis Hloov cov khoom tau saib thiab kho cov lej SQL.
