Cov txheej txheem:

Kuv SQL Server version yog dab tsi?
Kuv SQL Server version yog dab tsi?

Video: Kuv SQL Server version yog dab tsi?

Video: Kuv SQL Server version yog dab tsi?
Video: Npau Suav Hlub by Mang Vang [Music video] 2024, Hlis ntuj nqeg
Anonim

Thawj yog los ntawm kev siv Enterprise Manager lossis SQL Server Management Studio thiab txoj nyem rau ntawm lub npe piv txwv thiab xaiv Cov Khoom. Hauv ntu dav dav koj yuav pom cov ntaub ntawv xws li ntawm cov screenshots hauv qab no. Qhov "Product version "los yog" Version " muab rau koj ib tug xov tooj ntawm cov version uas yog ntsia.

Hais txog qhov no, kuv muaj dab tsi version ntawm SQL Server?

Thawj yog los ntawm kev siv Enterprise Manager lossis SQL Server Management Studio thiab txoj cai nyem rau ntawm lub npe piv txwv thiab xaiv Properties. Hauv ntu dav dav koj yuav pom cov ntaub ntawv xws li ntawm cov screenshots hauv qab no. Qhov "Product version "los yog" Version " muab rau koj ib tug xov tooj ntawm cov version uas yog ntsia.

Ib sab saum toj no, kuv tuaj yeem qhia li cas version ntawm SQL Server nyob ntawm Windows?

  1. Kauj ruam 1 - Qhib lub qhov rais hais kom ua ntawm lub tshuab uas SQL tau nruab.
  2. Kauj ruam 2 -SQLCMD -S servernameinstancename (qhov twg servernameb = lub npe ntawm koj lub server, thiab instancename yog lub npe ntawm SQL piv txwv).
  3. Kauj ruam 3 - xaiv @@version.
  4. Kauj ruam 4 -Thaum 2 → tam sim ntawd ntaus mus thiab ntaus nkag.

Kuj paub, kuv yuav nrhiav tau li cas version ntawm SQL database?

Txheeb xyuas SQL Server version thiab piv txwv

  1. Nkag mus rau Windows Server system hosting koj SQL Server database.
  2. Qhib lub qhov rais hais kom ua.
  3. Ua raws li cov lus txib hauv qab no:
  4. Nkag mus xaiv @@version thiab nias.
  5. Ntawm qhov 2> tam sim no, ntaus mus thiab nias.

Kuv tuaj yeem qhia tau li cas yog SQL Server yog Express Edition?

Yuav ua li cas los txiav txim seb SQL Server yog Tag Nrho lossis Express Version

  1. Nias Windows Logo Key + R kom qhib lub qhov rais khiav.
  2. Ntaus ib qho ntawm cov hauv qab no hauv Open field:
  3. Nyem OK los qhib SQL Server Configuration Manager qhov rais.
  4. Nyem rau qhov tseem ceeb SQL Server Services.
  5. Right-click lub SQL Server (Instance) kev pabcuam.

Pom zoo: