--视图设计器不支持case的--你在查询分析器中建视图就可以了,写上下面的语句,按F5执行 create view 视图名 as select user_id,case when user_id=VL_BuyUser then VL_Price else VL_BuyUserPrice end as Price from 表
按楼上的做法是可以的. create view 视图名 as select user_id,case when user_id=VL_BuyUser then VL_Price else VL_BuyUserPrice end as Price from 表另一种做法是:点击视图,右键属于,直接把SQL语名填充进出也行的. create view 视图名 as select user_id,case when user_id=VL_BuyUser then VL_Price else VL_BuyUserPrice end as Price from 表
收入应该为:300+0+0+0+(500-400)UserID=42的收入为:400+0+0
怎么会了!肯定可以呀!
create view 视图名
as
select user_id,case when user_id=VL_BuyUser then VL_Price else VL_BuyUserPrice end as Price from 表
create view 视图名
as
select user_id,case when user_id=VL_BuyUser then VL_Price else VL_BuyUserPrice end as Price from 表另一种做法是:点击视图,右键属于,直接把SQL语名填充进出也行的.
create view 视图名
as
select user_id,case when user_id=VL_BuyUser then VL_Price else VL_BuyUserPrice end as Price from 表