摘要: 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 阅读全文
posted @ 2012-04-19 15:57 彭满意 阅读(1242) 评论(0) 推荐(0) 编辑