是什么导致“ ubquery返回的值超过1个”错误?
技术问答
223 人阅读
|
0 人回复
|
2023-09-12
|
我不知道为什么我会收到此错误:-
$ N9 }1 h8 x$ mSubquery returned more than 1 value. This is not permitted when the subquery follows =, !=, , >= or when the subquery is used as an expression.
' W& E$ B2 O- K& _5 w% U9 UThe statement has been terminated.
" n" ?0 H4 `7 a; Z- F$ O我正在尝试运行此查询:( t+ } z# Y! f+ l
ALTER TABLE Test1 NOCHECK CONSTRAINT ALL# M# N4 a1 o! F( b; M& \$ C
ALTER TABLE Test2 NOCHECK CONSTRAINT ALL
4 y' _* M7 n2 U% ?2 H% L @% y) L2 x" D/ J
UPDATE Test1
2 I: ]8 c0 X' W iSET ID= '05f6c6b4-63ff-45b2-a5e2-920d5dce3e45' 9 o' q! L4 X, v% M5 ~6 P( J
WHERE ID = '05e6c6b4-63ff-45b2-a5e2-920d5dce3e45'; $ U. E% v5 t! e* U- b
UPDATE Test2 9 t1 m/ G. h% w! x( m6 T/ H
SET ID = '05f6c6b4-63ff-45b2-a5e2-920d5dce3e45' ,7 v% W: S9 P7 J' Y$ E4 M- v1 {2 D4 R! m
SpecID = NULL ,6 _1 w3 I |% V" G
RefLastName = 'Dummy' ,+ M$ ]: i' l/ D! p2 [) t& Q' A
RefFirstName = 'First Name' ,
2 E! r2 P( B- cRefMiddleName = NULL ,
: r$ }* l" {! y7 b" vRefPhone1 = '111444444' ,; e% K5 F- K: p& _+ I4 B R/ I6 T
RefPhone2 = '2121222' ,
6 ]% B3 N; l, `8 F7 aRefFax = '222222' ,' @, w" M" T% K3 d* Q4 o {
RefEmail = 'xxxxxxx@hotmail.ca'
# T0 ~! U9 E. X0 ]0 @3 ^- i# sWHERE 1 w! v6 {, g$ v3 }5 T- h8 y
RefID = '05e6c6b4-63ff-45b2-a5e2-920d5dce3e45'
# H) k2 n: ?. Y0 h8 L( t2 Q9 _! qALTER TABLE Test1 WITH CHECK CHECK CONSTRAINT ALL' r) \! P7 H6 Z& x! `: z
ALTER TABLE Test2 WITH CHECK CHECK CONSTRAINT ALL
% C/ {& Q0 w9 k4 `5 c# e
$ x' x* F' |" q. l: d1 T解决方案: |
|
|
|
|
|