22,207
社区成员
发帖
与我相关
我的任务
分享
AND (VVV=ISNULL(@VVV,'') OR (VVV IS NULL AND ISNULL(@VVV,'') = ''))
VVV=ISNULL(@VVV,'')
OR VVV IS NULL AND ISNULL(@VVV,'') = ''
IF NOT EXISTS(SELECT 0 FROM TABLE WHERE UUU=@UUU AND VVV=ISNULL(@VVV,'') AND WWW=ISNULL(@WWW,'') AND XXX=ISNULL(@XXX,'') AND YYY=ISNULL(@YYY,0) AND ZZZ=ISNULL(@ZZZ,0))
INSERT INTO TABLE (UUU,VVV,WWW,XXX,YYY,ZZZ) VALUES(@UUU,@VVV,@WWW,@XXX,@YYY,@ZZZ)
ELSE
UPDATE TABLE SET AAA=@AAA WHERE UUU=@UUU AND VVV=ISNULL(@VVV,'') AND WWW=ISNULL(@WWW,'') AND XXX=ISNULL(@XXX,'') AND YYY=ISNULL(@YYY,0) AND ZZZ=ISNULL(@ZZZ,0)
先UPDATE..
然后判断
IF @@ROWCOUNT = 0
--再INSERT