是什么导致“ ubquery返回的值超过1个”错误？
技术问答
61 人阅读
|
0 人回复
|
2023-09-12
|
|
我不知道为什么我会收到此错误：-
; H5 K# ?0 o& ^Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, , >= or when the subquery is used as an expression.! ^% z% [& s7 q
The statement has been terminated.9 e/ E9 i6 L4 n. p
我正在尝试运行此查询：
* m, ^3 l8 P6 |0 OALTER TABLE Test1 NOCHECK CONSTRAINT ALL
% l5 v. H' F* dALTER TABLE Test2 NOCHECK CONSTRAINT ALL1 o8 e! H0 ^$ o$ P% [# |1 J
" c5 y! p7 c, o( F! C! D2 Q: ~
UPDATE Test1
: |& L; n) `" V) D/ z6 j" MSET ID= '05f6c6b4-63ff-45b2-a5e2-920d5dce3e45' & h9 ?7 g3 J/ ]5 ^7 M% l
WHERE ID = '05e6c6b4-63ff-45b2-a5e2-920d5dce3e45'; ' M! c& F, c0 D2 c7 u9 ^, U
UPDATE Test2 $ g5 N) r8 ~0 n9 C" L; V
SET ID = '05f6c6b4-63ff-45b2-a5e2-920d5dce3e45' ,4 J* j" n# [. ~3 `- @
SpecID = NULL ,
9 W5 w; I# y" k3 j+ S9 i3 G% a c" y- }RefLastName = 'Dummy' ,4 E/ a! f# ~' c& R8 D+ E
RefFirstName = 'First Name' ,- V3 c0 F7 k) ]0 Q! I1 m
RefMiddleName = NULL ,$ C- C" `+ ?1 F. Q' w$ L
RefPhone1 = '111444444' ,
; S4 O. J7 O& s; m" g1 I% eRefPhone2 = '2121222' ,3 C0 y( n; l& D3 V1 W7 d" p
RefFax = '222222' ,
" J; ?* ?4 a. L6 T' _/ _9 D8 PRefEmail = 'xxxxxxx@hotmail.ca'
& v! Y# G) L" d# tWHERE j( V) V' `( x- E, k) }
RefID = '05e6c6b4-63ff-45b2-a5e2-920d5dce3e45'
0 Q- g3 ]1 o6 I9 Z/ Y) z) Y" ]! w9 ^ALTER TABLE Test1 WITH CHECK CHECK CONSTRAINT ALL/ F+ w; F# E& ^% j4 A5 d4 G
ALTER TABLE Test2 WITH CHECK CHECK CONSTRAINT ALL
. ~7 X# l; _9 W! K% Q: k 9 M) O! B8 ^) Q7 m, N% {) ^/ N
解决方案: |
|
|
|
|
|
|
|
|
|
