存储过程里面加入条件判断分支就行了大致是:DECLARE @myVar [类型]SELECT @myVar=[列] FROM [表] WHERE 条件IF @myVar=xxxBEGIN UPDATE ....ENDELSE IF @myVar=xxxxxBEGIN UPDATE ....ENDELSE IF .........