update 怎么用if else 选择执行两者之一的语句呀？

[chenyong2010320]

CREATE VIEW dbo.C
AS
SELECT emp_id,charge_money,card_balance,op_date,1 as u
from mchargerecords
union
select emp_id,card_consume,card_balance,sign_time ,0 as u
from Mealrecords



update employee set last_balance=
if(c.u=0)
ISNULL((select top 1 charge_money from c where emp_id=employee.emp_id order by op_date),0)+

ISNULL((select top 1 card_balance from c where emp_id=employee.emp_id order by op_date),0)from c where employee.emp_id ='060359'

else
ISNULL((select top 1 card_balance from c where emp_id=employee.emp_id order by op_date),0)-

ISNULL((select top 1 charge_money from c where emp_id=employee.emp_id order by op_date),0) from c where employee.emp_id ='060359'

[飘零一叶]

case when

[xiaoxiangqing]

只能用case when来判断就行了

[「已注销」]

update employee set last_balance=
case c.u when 0 then 
ISNULL((select top 1 charge_money from c where emp_id=employee.emp_id order by op_date),0)+

ISNULL((select top 1 card_balance from c where emp_id=employee.emp_id order by op_date),0)
from c where employee.emp_id ='060359' 

else 
ISNULL((select top 1 card_balance from c where emp_id=employee.emp_id order by op_date),0)-

ISNULL((select top 1 charge_money from c where emp_id=employee.emp_id order by op_date),0) end
from c where employee.emp_id ='060359'

[「已注销」]

sample:

UPDATE b 
SET bno = CASE id WHEN 1 THEN 'ddd' ELSE 'eee' END 
FROM book b

id          Bno  Bclass       Bchubanshe                     Bzuozhe
----------- ---- ------------ ------------------------------ --------------------
1           ddd  f            d                              f00
2           eee  a            a                              a00
3           eee  f            df                             f00
4           eee  sdf          asdf                           sdf00
7           eee  sdf          fdsa                           sdf00
12          eee  df           a                              df00

(6 row(s) affected)

[bancxc]

case when

[billpu]

case when then else end

[chenyong2010320]

谢谢 太感谢了……