摘要:
sqlserver版:ifexists(selectidfromwaynejiangwhereid=1)updatewaynejiangsetname='XX'whereid=1elseinsertintowaynejiang(id,name)values(1,'XX')oracle版:mergeintowaynejiangusing(select1asid,'XX'asnamefromdual)aon(waynejiang.id=a.id)whenmatchedthenupdatesetname='XX'whereid=1whe 阅读全文