select convert(char(10),passedtime,102),convert(char(8),passedtime,108)
,tollcenterno,tollgateno,roadwayno,
left(cardno, 5),right(cardno, 10),cartype,
charge,carno,
case cardstatus
when '01' then '非法'
when '02' then '正常'
when '03' then '挂失'
when '04' then '临界'
when '05' then '透支'
when '06' then '销卡'
when '07' then '免费'
when '08' then '无卡'
when '09' then '月卡'
when '10' then '优惠'
end
from PassedCars
where passedtime between @startdatetime and @enddatetime
怎样将上面的语句赋值给varchar型字符串(要保留Select语句中的单引号)?
---------------------------------------------------------------
declare @Sql varchar(2000)
set @Sql='select convert(char(10),passedtime,102),convert(char(8),passedtime,108),tollcenterno,tollgateno,roadwayno, left(cardno, 5),right(cardno, 10),cartype, charge,carno,case cardstatus when ''01'' then ''非法'' when ''02'' then ''正常'' when ''03'' then ''挂失'' when ''04'' then ''临界'' when ''05'' then ''透支'' when ''06'' then ''销卡'' when ''07'' then ''免费'' when ''08'' then ''无卡'' when ''09'' then ''月卡'' when ''10'' then ''优惠'' end from PassedCars where passedtime between @startdatetime and @enddatetime'
把一个单引号换成两个单引号
---------------------------------------------------------------
你是不是放到字段里，那可能是你的字段不够长。
如果放到varchar变量里，那可能是你的varchar变量定义不够长。
用declare @Sql varchar(2000)
^^^^^^