IF NOT EXISTS(SELECT * FROM USER WHERE USERID='''+AUSERID+'''') BEGIN
INSERT INTO USER ..WHERE USERID ='''+AUSERID+'''';
END ELSE BEGIN
UPDATE USER SET USERID = '''+AUSERID+''''
END
...全文
807打赏收藏
求一简单SQL
在ACCESS中如何用最简单SQL实现下面要求(ACCESS!!!),如果要一步步写,要三步呀 IF NOT EXISTS(SELECT * FROM USER WHERE USERID='''+AUSERID+'''') BEGIN INSERT INTO USER ..WHERE USERID ='''+AUSERID+''''; END ELSE BEGIN UPDATE USER SET USERID = '''+AUSERID+'''' END