Cov txheej txheem:

Kuv yuav pib SQL Server Management Studio li cas?
Kuv yuav pib SQL Server Management Studio li cas?

Video: Kuv yuav pib SQL Server Management Studio li cas?

Video: Kuv yuav pib SQL Server Management Studio li cas?
Video: Data Science with Python! Analyzing File Types from Avro to Stata 2024, Hlis ntuj nqeg
Anonim

Txhawm rau pib SQL Server Management Studio

  1. Nyob rau tam sim no versions ntawm Windows, nyob rau hauv Pib paj, typ SSMS , thiab tom qab ntawd nyem Microsoft SQL Server Management Studio .
  2. Thaum siv cov qub versions ntawm Windows, ntawm qhov Pib ntawv qhia zaub mov, taw tes rau Txhua Qhov Kev Pabcuam, taw rau Microsoft SQL Server , thiab ces nias SQL Server Management Studio .

Khaws qhov no hauv kev pom, Kuv yuav nrhiav SQL Server Management Studio li cas?

Yuav ua li cas nkag mus " Management Studio "Tam sim no, peb npaj qhib" Management Studio . Mus rau Start Menu> Programs> Microsoft SQL Server Cov cuab yeej 18> Microsoft SQL Server Management Studio 18. Hauv qab 'Txuas mus rau Server ' npo yuav tshwm.

Kuj Paub, Kuv yuav ua li cas thiaj tsim tau ib lub database hauv zos? Tsim Local Database Siv Microsoft SQL Server

  1. Mus rau Pib thiab tshawb rau Microsoft SQL Server.
  2. Txhawm rau tsim cov ntaub ntawv hauv zos, koj xav tau Server ua ntej.
  3. Tam sim no, koj txuas nrog Server, yog li koj tuaj yeem tsim cov ntaub ntawv.
  4. Koj yuav pom lub qhov rais thaum nyem rau ntawm qhov kev xaiv database tshiab.
  5. Tam sim no, koj tuaj yeem pom cov ntaub ntawv tshiab tshwm sim hauv cov ntawv qhia zaub mov hauv Object Explorer.

Kuj kom paub, Kuv tuaj yeem tsim kuv tus kheej SQL Server li cas?

  1. Qhib Microsoft SQL Management Studio.
  2. Txuas mus rau lub cav database siv cov ntaub ntawv tus thawj tswj xyuas cov ntaub ntawv pov thawj.
  3. Nthuav lub server node.
  4. Txoj cai nyem Databases thiab xaiv New Database.
  5. Sau lub npe database thiab nyem OK los tsim cov ntaub ntawv.

Kuv yuav nrhiav tau lub npe neeg rau zaub mov rau SQL Server Management Studio li cas?

Qhib SQL Server Kev teeb tsa Tus thawj tswj (Nrhiav nws hauv Start menu). Nyem rau SQL Server Kev pabcuam. Qhov piv txwv npe ntawm SQL Server yog nyob rau hauv kab lus inline nrog SQL Server kev pabcuam. Yog tias nws hais MSSQLSERVER, ces nws yog qhov piv txwv qub.

Pom zoo: