when 40 then '1小时降雨:'+cast((select th1yp from #tmp_maxRain where datadate='''+convert(varchar(10),@TM,20))+''')as char(10))+' 超过警戒雨量:'+cast(@diff1h as char(8))datadate格式为:2010-08-13,请问怎么改。
when 40 then '1小时降雨:'+cast((select th1yp from #tmp_maxRain where datadate='''+convert(varchar(10),@TM,20))+''')as char(10))+' 超过警戒雨量:'+cast(@diff1h as char(8))datadate格式为:2010-08-13,请问怎么改。
select convert(varchar(10),getdate(),120))难道有问题?
楼主没加end吧.......
另外:sql中组字符串时单引号要用CHAR(39)
where datadate='+convert(varchar(10),@TM,120))+') as char(8))+' 超过警戒雨量:'+cast(@diff1h as char(8))
就想以字符串输出来就行
when 40 then '1小时降雨:'+cast((select isnull(th1yp,0) from #tmp_maxRain
where datadate=convert(varchar(10),@TM,120)+' 超过警戒雨量:'+cast(@diff1h as char(8))