子查询在SSMS 2016中返回了多个值 [英] Subquery returned more than 1 value in SSMS 2016

问题描述

我有一个使用SSMS 2014在SQL Server 2014 x64 Express Edition中创建的数据库，并且该数据库中有一些表.我用这个tsql备份数据库

BACKUP DATABASE dbFile
TO DISK='D:\dbFile_170125.bak' WITH FORMAT;

在另一台计算机上，我具有带有SSMS 2016的SQL Server 2016 x64 Express Edition. 我创建了新数据库，然后使用替换选项从文件"dbFile_170125.bak"还原数据库.恢复成功.

问题是当我在SSMS 2016的对象资源管理器中展开表时，显示错误:

子查询返回了多个值.当 子查询遵循=，！=，<，< =，>，> =或当子查询用作 一种表达. (Microsoft SQL Server，错误:512)

在SSMS 2014中，没有这样的问题. 也许有人可以帮助我. 谢谢.

解决方案

似乎有多个用户遇到了问题，目前，唯一的解决方案是回滚更新.

https://social.msdn.microsoft.com/Forums/sharepoint/zh-CN/22c906d5-fbbb-474f-9b63 -08abb1b0a9bc/ssms-2016-展开表子查询返回大于1值时出错?forum = ssdt

这是错误报告

The problem is when i expand the Tables in Object Explorer in SSMS 2016, it show error :

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. (Microsoft SQL Server, Error:512)

In SSMS 2014, there is no problem like that. Perhaps someone can help me. Thanks.

解决方案

Multiple users have the problem, it seems, for now, the only solution is to roll back the update.

https://social.msdn.microsoft.com/Forums/en-US/27c39cf6-555a-4dad-b1b3-db14b63ba5e6/ssms-2016-error-when-expanding-tables?forum=sqltools

https://social.msdn.microsoft.com/Forums/sharepoint/en-US/22c906d5-fbbb-474f-9b63-08abb1b0a9bc/ssms-2016-error-when-expanding-tables-subquery-returned-more-than-1-value?forum=ssdt

edit: and here is the bug report https://feedback.azure.com/forums/908035-sql-server/suggestions/32898901-microsoft-sql-server-management-studio-error-on

这篇关于子查询在SSMS 2016中返回了多个值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！