11,850
社区成员
发帖
与我相关
我的任务
分享
IF NOT EXISTS(SELECT 0 FROM TABLE WHERE UUU=@UUU AND ISNULL(VVV,'')=ISNULL(@VVV,'') AND ISNULL(WWW,'')=ISNULL(@WWW,'') AND ISNULL(XXX,'')=ISNULL(@XXX,'') AND ISNULL(YYY,0)=ISNULL(@YYY,0) AND ISNULL(ZZZ,0)=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 ISNULL(VVV,'')=ISNULL(@VVV,'') AND ISNULL(WWW,'')=ISNULL(@WWW,'') AND ISNULL(XXX,'')=ISNULL(@XXX,'') AND ISNULL(YYY,0)=ISNULL(@YYY,0) AND ISNULL(ZZZ,0)=ISNULL(@ZZZ,0))