SQL Server 2016 Enterprise Core - duplicate (do not use)SQL Server 2016 Enterprise - duplicate (do not use)SQL Server 2016 Developer - duplicate (do not use)SQL Server 2016 Standard - duplicate (do not use)SQL
Express - duplicate (do not use)SQL Server 2014 Standard - duplicate (do not use)SQL Server 2016 Developer - duplicate (do not use)SQL Server 2016 Enterprise - duplicate (do not use)SQL Server 2016 Enterprise Core - duplicate (do not use)SQL Server 2016 Standard - duplicate (do not use...
应用对象SQL Server 2014 Developer - duplicate (do not use) SQL Server 2014 Enterprise - duplicate (do not use) SQL Server 2014 Standard - duplicate (do not use) SQL Server 2012 Developer SQL Server 2012 Enterprise SQL Server 2012 Standard...
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance SQL database in Microsoft Fabric The built-in hierarchyid data type makes it easier to store and query hierarchical data. hierarchyid is optimized for representing trees, which are the most common type of hierarchical data. ...
Sets Transact-SQL and query processing behaviors to be compatible with the specified version of the Database Engine.
database_name The name of the database to be modified. COMPATIBILITY_LEVEL { 170 | 160 | 150 | 140 | 130 | 120 | 110 | 100 | 90 | 80 } The version of SQL Server with which the database is to be made compatible. The following compatibility level values can be configured (not al...
duplicate (do not use)SQL Server 2014 Business Intelligence - duplicate (do not use)SQL Server 2014 Developer - duplicate (do not use)SQL Server 2014 Enterprise - duplicate (do not use)SQL Server 2014 Enterprise Core - duplicat...
在SQL Server 和 SQL 托管实例上,需要 VIEW SERVER STATE 权限。 在SQL 数据库 基本、S0和S1 服务目标上,对于 弹性池、服务器管理员 帐户、Microsoft entra 管理员 帐户或 ##MS_ServerStateReader##服务器角色 的成员身份。 在所有其他 SQL 数据库服务目标上,需要对数据库具有 VIEW DATABASE STATE 权限或 ##MS...
SQL Database の Basic、S0、S1 サービス対象、および Elastic Pool のデータベースの場合、サーバー管理者アカウント、Microsoft Entra 管理者アカウント、または ##MS_ServerStateReader##サーバー ロールのメンバーシップが必要です。 他のすべての SQL Database サービス目標では、データベー...
Cryptography in SQL Server Data Access Tracing in SQL Server 2008 Database Encryption in SQL Server 2008 Enterprise Edition Embedding SQL Server 2008 Express in an Application Engine Separation of Duties for the Application Developer FILESTREAM Storage in SQL Server 2008 Geo-Replication Performance Gains...