是什么导致“ ubquery返回的值超过1个”错误?
技术问答
224 人阅读
|
0 人回复
|
2023-09-12
|
我不知道为什么我会收到此错误:-
5 c" D4 A7 m: ?& I rSubquery returned more than 1 value. This is not permitted when the subquery follows =, !=, , >= or when the subquery is used as an expression.; O9 E: P, I/ Y0 m. G9 ?" Z
The statement has been terminated.
* T" g3 o. ]! j S0 b+ B" K. I/ }我正在尝试运行此查询:/ A8 u! o1 c: G
ALTER TABLE Test1 NOCHECK CONSTRAINT ALL
' D" Y: F# h: U; HALTER TABLE Test2 NOCHECK CONSTRAINT ALL& @2 y- g; f9 `* A$ M
+ @2 v- W3 U5 C( b) B& X1 y
UPDATE Test1
& } I7 i7 n/ z( `8 M% kSET ID= '05f6c6b4-63ff-45b2-a5e2-920d5dce3e45'
$ d0 w2 @! c2 c1 x4 DWHERE ID = '05e6c6b4-63ff-45b2-a5e2-920d5dce3e45';
# }2 H1 A; U f/ g% }+ gUPDATE Test2
" s# w+ y6 c4 @4 XSET ID = '05f6c6b4-63ff-45b2-a5e2-920d5dce3e45' ,
8 {8 n+ {/ V9 i6 m0 R2 OSpecID = NULL ,: g4 q# t& Z: E9 F" u
RefLastName = 'Dummy' ,5 {8 P* y. c6 K: G' y
RefFirstName = 'First Name' ,
! j% D Y/ s: URefMiddleName = NULL , [$ y5 d0 N# ]+ [- z
RefPhone1 = '111444444' ,
" i' q, c* @7 p) {3 e9 yRefPhone2 = '2121222' ,
3 z+ O/ s% O& l$ i0 gRefFax = '222222' ,. p' Z" \- W. U# C+ Z x% B
RefEmail = 'xxxxxxx@hotmail.ca' : C' B% h0 u) w1 e
WHERE ' n& n U& N2 n) _& v( h. _: R% J. p
RefID = '05e6c6b4-63ff-45b2-a5e2-920d5dce3e45'$ W1 n" ~+ j& G3 P; e4 x1 F
ALTER TABLE Test1 WITH CHECK CHECK CONSTRAINT ALL
$ A" @0 w3 t! ^! I' VALTER TABLE Test2 WITH CHECK CHECK CONSTRAINT ALL8 A: {7 K% P& z
. o, v: c3 @8 k/ j解决方案: |
|
|
|
|
|