hidrau
asked on
Is there any way to run a update with Case?
Hello Guys,
I have an update script:
the problem is that I need to create a script with price_sell diferent when I am in a determined table, for example:
how can I do that? Is it possible?
thanks
Alexandre
I have an update script:
update product set price_sell = 123.45 where code=45
the problem is that I need to create a script with price_sell diferent when I am in a determined table, for example:
update product set price_sell = case database='viadiesel' then 123.45 else 187.74 end if where code=45
how can I do that? Is it possible?
thanks
Alexandre
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER