SET COMPATIBILITY_LEVEL 用于设置MS SQL Server的兼容级别 MS SQL Server 2000:SET COMPATIBILITY_LEVEL=80 MS SQL Server 2005:SET COMPATIBILITY_LEVEL=90 MS SQL Server 2008:SET COMPATIBILITY_LEVEL=100 MS SQL Server 2012:SET COMPATIBILITY_LEVEL=110 最常使用方法: ALTER DATABASE [数据库名] SET COMPATIBI...
To set the compatibility level for merge publications, using: SQL Server Management Studio Transact-SQLUsing SQL Server Management StudioSet the compatibility level on the Subscriber Types page of the New Publication Wizard. For more information on accessing this wizard, see Create a Publication. ...
0xFFFF If an object has the 0xFFFF Unicode character as part of its name, it will be invalid after the upgrade if the database compatibility level is set to 90. Database with ID of 32767 This database ID is reserved in SQL Server 2005 for the resource database and any current databas...
external' 附近有语法错误。您可能需要将当前数据库的兼容级别设置为更高的值,以启用此功能。有关 ALTER DATABASE 的 SET COMPATIBILITY_LEVEL 选项的信息,请参见帮助。 解决方法: USE[master] GO ALTERDATABASE[MRP_NSDERPTEST]SETCOMPATIBILITY_LEVEL=90 ...
{ ON | OFF } } <sql_option> ::= { ANSI_NULL_DEFAULT { ON | OFF } | ANSI_NULLS { ON | OFF } | ANSI_PADDING { ON | OFF } | ANSI_WARNINGS { ON | OFF } | ARITHABORT { ON | OFF } | COMPATIBILITY_LEVEL = { 160 | 150 | 140 | 130 | 120 | 110 ...
For example, when stored procedure db1.dbo.sp1 calls stored procedure db2.dbo.sp2, stored procedure sp1 executes under the current compatibility level setting of database db1, and stored procedure sp2 executes under the current compatibility level setting of database db2. When a Transact-SQL ...
{ ON | OFF } } <sql_option> ::= { ANSI_NULL_DEFAULT { ON | OFF } | ANSI_NULLS { ON | OFF } | ANSI_PADDING { ON | OFF } | ANSI_WARNINGS { ON | OFF } | ARITHABORT { ON | OFF } | COMPATIBILITY_LEVEL = { 160 | 150 | 140 | 130 | 120 | 110 | 100 } | CONCAT_...
{ ON | OFF } } <sql_option> ::= { ANSI_NULL_DEFAULT { ON | OFF } | ANSI_NULLS { ON | OFF } | ANSI_PADDING { ON | OFF } | ANSI_WARNINGS { ON | OFF } | ARITHABORT { ON | OFF } | COMPATIBILITY_LEVEL = { 160 | 150 |...
{ ON | OFF } } <sql_option> ::= { ANSI_NULL_DEFAULT { ON | OFF } | ANSI_NULLS { ON | OFF } | ANSI_PADDING { ON | OFF } | ANSI_WARNINGS { ON | OFF } | ARITHABORT { ON | OFF } | COMPATIBILITY_LEVEL = { 160 | 150 | 140 | 130 | 120 | 110 | 100 } | CONCAT_...
{ ON | OFF } } <sql_option> ::= { ANSI_NULL_DEFAULT { ON | OFF } | ANSI_NULLS { ON | OFF } | ANSI_PADDING { ON | OFF } | ANSI_WARNINGS { ON | OFF } | ARITHABORT { ON | OFF } | COMPATIBILITY_LEVEL = { 160 | 150 | 140 | 130 | 120 | 110 | 100 }...