是什么导致“ ubquery返回的值超过1个”错误?
技术问答
222 人阅读
|
0 人回复
|
2023-09-12
|
我不知道为什么我会收到此错误:-
& R9 U* m, j# _* P( bSubquery returned more than 1 value. This is not permitted when the subquery follows =, !=, , >= or when the subquery is used as an expression.& N8 _" H; _ e5 z
The statement has been terminated.
; @1 l; b2 U" c我正在尝试运行此查询:2 w9 F6 X% @( D" K! v
ALTER TABLE Test1 NOCHECK CONSTRAINT ALL
' I& q9 m9 [; s/ [ c' EALTER TABLE Test2 NOCHECK CONSTRAINT ALL
6 K: g5 @# T9 r' y( t n. p) I
( \. R$ E/ n1 R! i r& c5 ~UPDATE Test1 ' p6 z3 F" ~, b6 E0 i+ |; r
SET ID= '05f6c6b4-63ff-45b2-a5e2-920d5dce3e45'
+ d: }6 f& |8 C% V1 F) rWHERE ID = '05e6c6b4-63ff-45b2-a5e2-920d5dce3e45';
3 o3 j' C; n: P9 q9 o2 mUPDATE Test2 % b& F. p+ ^, D1 {" e
SET ID = '05f6c6b4-63ff-45b2-a5e2-920d5dce3e45' , W3 c+ x. Z+ q8 Z: t8 A
SpecID = NULL ,* r8 }0 ?& `& P7 M {- D3 u) p
RefLastName = 'Dummy' ,, t g% O, M. n% F c! k5 h
RefFirstName = 'First Name' ,
; X$ G2 m/ M* [% S& r QRefMiddleName = NULL ,6 {' e+ ^- }# R1 ?: |8 [3 e
RefPhone1 = '111444444' ,
$ G% L- \0 u2 q! |RefPhone2 = '2121222' ,9 D: C o8 c3 ^9 G
RefFax = '222222' ,: @) J! a# N8 F8 Q1 q& l
RefEmail = 'xxxxxxx@hotmail.ca'
9 c' ~- U# Q- Z2 W' Q7 V: qWHERE
6 S3 _+ y" C! T) ~( r: iRefID = '05e6c6b4-63ff-45b2-a5e2-920d5dce3e45'0 c3 W6 x+ S$ E/ ^$ ~; Q: B3 h
ALTER TABLE Test1 WITH CHECK CHECK CONSTRAINT ALL
6 e6 i5 z' l: Z- f1 b( U/ B# UALTER TABLE Test2 WITH CHECK CHECK CONSTRAINT ALL
- b- A8 Y9 G! l0 n& @: M# f5 C 7 G% U7 d) t% E# {/ ]
解决方案: |
|
|
|
|
|