select cast(aa=(SELECT 11) as dec(18,2)) --不可行你必须将(select 11) cast 之后才能 赋给aa select aa=cast((SELECT 11) as dec(18,2))
select CurrencyRate = cast((SELECT CurrencyRate FROM HkCurrency WHERE CurrencyID = 1) as dec(18,2))select CurrencyRate = (SELECT cast(CurrencyRate as dec(18,2)) FROM HkCurrency WHERE CurrencyID = 1)
select cast(aa=(SELECT 11) as dec(18,2)) aa=(SELECT 11)这部分语法不对出错。 改成下面的就可以了 select cast((SELECT 11 AS aa) as dec(18,2))
赋给aa
select aa=cast((SELECT 11) as dec(18,2))
cast((SELECT CurrencyRate
FROM HkCurrency
WHERE CurrencyID = 1) as dec(18,2))select CurrencyRate =
(SELECT cast(CurrencyRate as dec(18,2))
FROM HkCurrency
WHERE CurrencyID = 1)
改成下面的就可以了
select cast((SELECT 11 AS aa) as dec(18,2))