条件查询时,使用TSQL 的CASE WHEN就不用一句一句或者一个一个串字符串了
eg:
select ProductID,ChannelID,ProductName,ProducerName,demo_url,Price_Original,ProductThumb,ProductIntro,updatetime,
'discount'=case when Discount<10.0 then CAST(Discount as varchar(4)) else '不打折' end,Price from PE_Product where ……