提示这样的错误消息 241,级别 16,状态 1,第 38 行
从字符串向 datetime 转换时失败。declare @s varchar(max)
declare @s2 varchar(100)
declare @s3 DateTime
declare @s4 varchar(100)
declare @s5 DateTime
declare @i int
set @s = ''
set @s2 = ''
set @s3 = ''
set @s4 = ''
set @s5 = ''select @s = @s + ''''+xslcountent+''','
from xslcountent
where datediff(day,xslshortdate ,getdate()) = 0 and zhrz='是'
order by xslshortdate
select
@i = @@rowcount,
@s = @s + replicate(''''',',10 - @i)select distinct @s2 = xslsourceguid
from xslcountent
where datediff(day,xslshortdate,getdate()) = 0 and zhrz='是'select distinct @s3 = xslshortdate
from xslcountent
where datediff(day,xslshortdate,getdate()) = 0 and zhrz='是'select distinct @s4 = xslsourcename
from xslcountent
where datediff(day,xslshortdate,getdate()) = 0 and zhrz='是'select distinct @s5 = xslshortdate
from xslcountent
where datediff(day,xslshortdate,getdate()) = 0 and zhrz='是'
set @s = @s + '''' + @s2 + '''' +convert(datetime,@s3,121)+ ''''+@s4 + ''''+convert(datetime,@s5,121)+ '''' if @i > 0
exec('insert worklog(workcontent1,workcontent2,workcontent3,workcontent4,workcontent5,workcontent6,workcontent7,workcontent8,workcontent9,workcontent10,usernameguid,workdate,username,longdatetime) select ' + @s)
从字符串向 datetime 转换时失败。declare @s varchar(max)
declare @s2 varchar(100)
declare @s3 DateTime
declare @s4 varchar(100)
declare @s5 DateTime
declare @i int
set @s = ''
set @s2 = ''
set @s3 = ''
set @s4 = ''
set @s5 = ''select @s = @s + ''''+xslcountent+''','
from xslcountent
where datediff(day,xslshortdate ,getdate()) = 0 and zhrz='是'
order by xslshortdate
select
@i = @@rowcount,
@s = @s + replicate(''''',',10 - @i)select distinct @s2 = xslsourceguid
from xslcountent
where datediff(day,xslshortdate,getdate()) = 0 and zhrz='是'select distinct @s3 = xslshortdate
from xslcountent
where datediff(day,xslshortdate,getdate()) = 0 and zhrz='是'select distinct @s4 = xslsourcename
from xslcountent
where datediff(day,xslshortdate,getdate()) = 0 and zhrz='是'select distinct @s5 = xslshortdate
from xslcountent
where datediff(day,xslshortdate,getdate()) = 0 and zhrz='是'
set @s = @s + '''' + @s2 + '''' +convert(datetime,@s3,121)+ ''''+@s4 + ''''+convert(datetime,@s5,121)+ '''' if @i > 0
exec('insert worklog(workcontent1,workcontent2,workcontent3,workcontent4,workcontent5,workcontent6,workcontent7,workcontent8,workcontent9,workcontent10,usernameguid,workdate,username,longdatetime) select ' + @s)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货