select case when acurrency = 'RMB' then round(latest_cost,2) else round(latest_cost/exchange_rate , 2) end as RMBprice
from product
where prdname =LTRIM(RTRIM( "71001崩 "))這樣的where條件用中文有什么問題?Server: Msg 207, Level 16, State 3, Line 1
列名 '71001崩 ' 无效。
from product
where prdname =LTRIM(RTRIM( "71001崩 "))這樣的where條件用中文有什么問題?Server: Msg 207, Level 16, State 3, Line 1
列名 '71001崩 ' 无效。
from product
where prdname =LTRIM(RTRIM( '71001崩 '))
from product
where prdname =LTRIM(RTRIM('71001崩 '))
from product
where prdname =LTRIM(RTRIM( [71001崩]))还是要这样
from product
where prdname =LTRIM(RTRIM('71001崩 '))
select case when acurrency = 'RMB' then round(latest_cost,2) else round(latest_cost/exchange_rate , 2) end as RMBprice
from product
where prdname =LTRIM(RTRIM('"71001崩 "'))
from product
where prdname =LTRIM(RTRIM( '71001崩 '))
from product
where prdname =LTRIM(RTRIM('71001崩 '))
where prdname =LTRIM(RTRIM('71001崩 '))