如何更改SQL Server实例的版本？(How do I change the version of my SQL Server instance?)

如何更改SQL Server实例的版本？(How do I change the version of my SQL Server instance?)

我正在使用sql server 2012 express.But当我执行'@@ version'查询它显示“Microsoft SQL Server 2005 - 9.00.3042.00”并且大多数查询如'fetch'不再有效。我怎么能改变数据库引擎回到sql server 2012？

i am using sql server 2012 express.But when i execute '@@version' query it is showing "Microsoft SQL Server 2005 - 9.00.3042.00" and most of the queries like 'fetch' is not working anymore.How can i change the database engine back to sql server 2012?

最满意答案

ALTER DATABASE database_name SET COMPATIBILITY_LEVEL = 110 ALTER DATABASE database_name SET COMPATIBILITY_LEVEL = 110