sql语句:SELECT CASE WHEN ISNULL(PresentPrice,0)-isnull(BuyingPrice,0)=0 THEN '无值'
else ISNULL(PresentPrice,0)-isnull(BuyingPrice,0) end
FROM Share202205
解决:数据库中默认不能为两种类型的数据类型。
SELECT CASE WHEN ISNULL(PresentPrice,0)-isnull(BuyingPrice,0)=0 THEN '无值'
else cast(ISNULL(PresentPrice,0)-isnull(BuyingPrice,0) AS varchar) end
FROM Share202205
主要知识点:
字段类型的转化:
(1) 字符串转int型:convert(int,字符串) ;cast(字符串 as int)(2)数字转string型:convert(varchar(10),数字) ;cast(数字 as varchar(10))