MSSQL 各个发行版本版本号以及Compact 版本号-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

MSSQL 各个发行版本版本号以及Compact 版本号

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 05:37 PM

compactmssqlissued

终于开始写博客了。不要笑

终于开始写博客了。

不要笑啊。

下面是MSSQL 的发行版本以及版本号。自己整理的。

SQL Server 2012 版本信息
发行版      产品版本
SQL Server 2012 Service Pack 1      11.00.3000.00
SQL Server 2012 RTM    　　　　　　11.00.2100.60

SQL Server 2008 R2 版本信息
发行版产品版本

SQL Server 2008 R2 Service Pack 2 10.50.4000.0
SQL Server 2008 R2 Service Pack 1 10.50.2500.0
SQL Server 2008 R2 RTM 　　　　 10.50.1600.1

SQL Server 2008 版本信息
发行版      产品版本
SQL Server 2008 Service Pack 3   10.00.5500.00
SQL Server 2008 Service Pack 2   10.00.4000.00
SQL Server 2008 Service Pack 1   10.00.2531.00
SQL Server 2008 RTM    　　　　 10.00.1600.22

SQL Server 2005 版本信息
发行版      产品版本
SQL Server 2005 Service Pack 4   9.00.5000.00
SQL Server 2005 Service Pack 3   9.00.4035
SQL Server 2005 Service Pack 2   9.00.3042
SQL Server 2005 Service Pack 1   9.00.2047
SQL Server 2005 RTM    　　　　 9.00.1399

SQL Server 2000 版本信息
发行版      产品版本
SQL Server 2000 Service Pack 4   　　8.00.2039
SQL Server 2000 Service Pack 3   　　8.00.760
SQL Server 2000 Service Pack 3   　　8.00.760
SQL Server 2000 Service Pack 2   　　8.00.534
SQL Server 2000 Service Pack 1   　　8.00.384
SQL Server 2000 RTM 　　　　　　　　8.00.194

下面找到的SQL SERVER Compact 的发行版本号。给大家参考。

Product Name

Release Vehicle

Version

SQL Server 2005 Mobile Edition

Visual Studio 2005 RTM

3.0.5206

SQL Server 2005 Mobile Edition

SQL Server 2005 RTM

3.0.5207

SQL Server 2005 Compact Edition

Visual Studio 2005 SP1

3.0.5300

SQL Server 2005 Compact Edition

SQL Server 2005 SP2

3.0.5300

SQL Server 2005 Compact Edition

Download Center

3.0.5300

SQL Server 2005 Compact Edition

Windows Mobile 6.0

3.0.5289

SQL Server Compact 3.5 Beta1

Visual Studio 2008 Beta1

3.5.5339

SQL Server Compact 3.5 Beta2

Visual Studio 2008 Beta2

3.5.5365

SQL Server Compact 3.5 RTM

Visual Studio 2008 RTM

3.5.5386

SQL Server Compact 3.5 RTM

Download Center

3.5.5386

SQL Server Compact 3.5 SP1 Beta

SQL Server 2008 CTP5 OR

SQL Server 2008 Nov07 CTP

3.5.5608

SQL Server Compact 3.5 SP1 Beta for ADO.NET Entity Framework Provider Beta

Download Center

3.5.5626

SQL Server Compact 3.5 SP1 Beta

SQL Server 2008 CTP6 OR

SQL Server 2008 Feb08 CTP

3.5.5626

SQL Server Compact 3.5 SP1 RTM

Visual Studio 2008 SP1 RTM

SQL Server Compact 3.5 SP1 RTM

SQL Server 2008 RTM

SQL Server Compact 3.5 SP1 RTM

with .NET Framework 4 Beta Support

Visual Studio 2010 Beta 1

3.5.5802

SQL Server Compact 3.5 SP2 Beta

Microsoft Visual Studio 2010 and .NET Framework 4 Beta 2

3.5.8044

SQL Server Compact 3.5 SP2 Beta

SQL Server Compact 3.5 SP2 Beta for Windows Desktop Web Download

3.5.8049

SQL Server Compact 3.5 SP2 Release Candidate

Visual Studio 2010 and .NET Framework 4 Release Candidate

3.5.8078

SQL Server Compact 3.5 SP2

1. Visual Studio 2010 and .NET Framework 4 RTM

2. SQL Server Compact 3.5 SP2 for Windows Desktop

3.5.8080

，

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

What Are the Limitations of Using Views in MySQL?May 14, 2025 am 12:10 AM

MySQLviewshavelimitations:1)Theydon'tsupportallSQLoperations,restrictingdatamanipulationthroughviewswithjoinsorsubqueries.2)Theycanimpactperformance,especiallywithcomplexqueriesorlargedatasets.3)Viewsdon'tstoredata,potentiallyleadingtooutdatedinforma

Securing Your MySQL Database: Adding Users and Granting PrivilegesMay 14, 2025 am 12:09 AM

ProperusermanagementinMySQLiscrucialforenhancingsecurityandensuringefficientdatabaseoperation.1)UseCREATEUSERtoaddusers,specifyingconnectionsourcewith@'localhost'or@'%'.2)GrantspecificprivilegeswithGRANT,usingleastprivilegeprincipletominimizerisks.3)

What Factors Influence the Number of Triggers I Can Use in MySQL?May 14, 2025 am 12:08 AM

MySQLdoesn'timposeahardlimitontriggers,butpracticalfactorsdeterminetheireffectiveuse:1)Serverconfigurationimpactstriggermanagement;2)Complextriggersincreasesystemload;3)Largertablesslowtriggerperformance;4)Highconcurrencycancausetriggercontention;5)M

MySQL: Is it safe to store BLOB?May 14, 2025 am 12:07 AM

Yes,it'ssafetostoreBLOBdatainMySQL,butconsiderthesefactors:1)StorageSpace:BLOBscanconsumesignificantspace,potentiallyincreasingcostsandslowingperformance.2)Performance:LargerrowsizesduetoBLOBsmayslowdownqueries.3)BackupandRecovery:Theseprocessescanbe

MySQL: Adding a user through a PHP web interfaceMay 14, 2025 am 12:04 AM

Adding MySQL users through the PHP web interface can use MySQLi extensions. The steps are as follows: 1. Connect to the MySQL database and use the MySQLi extension. 2. Create a user, use the CREATEUSER statement, and use the PASSWORD() function to encrypt the password. 3. Prevent SQL injection and use the mysqli_real_escape_string() function to process user input. 4. Assign permissions to new users and use the GRANT statement.

MySQL: BLOB and other no-sql storage, what are the differences?May 13, 2025 am 12:14 AM

MySQL'sBLOBissuitableforstoringbinarydatawithinarelationaldatabase,whileNoSQLoptionslikeMongoDB,Redis,andCassandraofferflexible,scalablesolutionsforunstructureddata.BLOBissimplerbutcanslowdownperformancewithlargedata;NoSQLprovidesbetterscalabilityand

MySQL Add User: Syntax, Options, and Security Best PracticesMay 13, 2025 am 12:12 AM

ToaddauserinMySQL,use:CREATEUSER'username'@'host'IDENTIFIEDBY'password';Here'showtodoitsecurely:1)Choosethehostcarefullytocontrolaccess.2)SetresourcelimitswithoptionslikeMAX_QUERIES_PER_HOUR.3)Usestrong,uniquepasswords.4)EnforceSSL/TLSconnectionswith

MySQL: How to avoid String Data Types common mistakes?May 13, 2025 am 12:09 AM

ToavoidcommonmistakeswithstringdatatypesinMySQL,understandstringtypenuances,choosetherighttype,andmanageencodingandcollationsettingseffectively.1)UseCHARforfixed-lengthstrings,VARCHARforvariable-length,andTEXT/BLOBforlargerdata.2)Setcorrectcharacters

See all articles