是什么导致“ ubquery返回的值超过1个”错误？

阿拴

我不知道为什么我会收到此错误：-
+ i7 n! Z# d+ ?" C5 m; y, P  TSubquery returned more than 1 value. This is not permitted when the subquery follows =, !=, , >= or when the subquery is used as an expression.
3 G$ y) @9 G+ l$ c- I" PThe statement has been terminated.
我正在尝试运行此查询：
% g& l) }. ~7 M0 W# x: Q% ^* HALTER TABLE Test1 NOCHECK CONSTRAINT ALL
# T# l% k5 \4 ^- MALTER TABLE Test2 NOCHECK CONSTRAINT ALL
8 ]* F6 G; D% w( k9 I& [, ?& v) k3 I
+ g' i! Z2 L- ]UPDATE Test1
SET ID= '05f6c6b4-63ff-45b2-a5e2-920d5dce3e45'
' g6 t$ G. k) R1 N7 xWHERE ID = '05e6c6b4-63ff-45b2-a5e2-920d5dce3e45';
9 B. e6 }* P5 hUPDATE Test2
; d- V. P5 j  ?& Q( i6 {, `6 l' Y  d3 pSET ID = '05f6c6b4-63ff-45b2-a5e2-920d5dce3e45' ,
SpecID = NULL ,
RefLastName = 'Dummy' ,
RefFirstName = 'First Name' ,
- s. F+ ]- d5 z7 g. i, o. QRefMiddleName = NULL ,
$ z" ~6 q( u! y. l" URefPhone1 = '111444444' ,
RefPhone2 = '2121222' ,
; g8 e: A* P. t( l0 E% iRefFax = '222222' ,
RefEmail = 'xxxxxxx@hotmail.ca'
WHERE
RefID = '05e6c6b4-63ff-45b2-a5e2-920d5dce3e45'
ALTER TABLE Test1 WITH CHECK CHECK CONSTRAINT ALL
5 i: e& g; m- ^2 e) yALTER TABLE Test2 WITH CHECK CHECK CONSTRAINT ALL
9 v+ a( N' R& f" G6 ~               
解决方案: