varchar数据类型转换成datetime数据类型

2006-11-07 02:07:05 615 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

关于.net网站的安全性问题以及解决方案的分析在面试的时候当面试官问道：“你知道怎么提高网站的安全性吗？”这个问题时，我总是回答的不够完整，所以今天我浏览了各大高手的博客，以及通过看书稍微总结一下，也许还是不完整，希望这方面高手也能出来指点一二。首先探讨一下，什么是网站的安全性？就网站而言，因为网站的定义有许多种，所以各种关于网站安全的定义也不同。有的定义为：网站安全就是保护网上保存的数据和流动的数据，不被别人偷看、窃取或者修改。也有阅读详情

declare @sql varchar(8000)
if exists (select object_id('temp_grcl'))
drop table temp_grcl
select @sql = 'select a.scph,a.cpdm,a.kh,a.jtdm,a.scsl,a.hgs,a.fps,a.rq,a.bz,
b.xm,c.gxmc,d.bz as hzxx,d.mc+''-''+d.dy+''-''+d.swsbsrl+''-''+d.djdm+''-''+d.jj+''-''+d.ts as gg,
d.mkts,d.mtzs,a.hgs/d.mkts/d.mtzs as hgks,f.fz,
case when c.gxmc = ''组装'' then case when d.mc like ''cl23b%'' then case when d.bz = ''3.5*7.5*7.2'' or d.bz = ''2.5*6.5*7.2'' then cast(a.hgs/44000.00 as dec(10,3))
when d.bz = ''4.5*9.5*7.2'' or d.bz = ''5.0*10*7.2'' then cast(a.hgs/34000.00 as dec(10,3))
when d.bz = ''6.0*11*7.2'' then cast(a.hgs/30000.00 as dec(10,3)) end
when d.mc = ''cl25'' then cast(a.hgs/30000.00 as dec(10,3)) end
when c.gxmc = ''卷绕'' then a.hgs/d.mkts/d.mtzs*f.fz
end as wcgs

into temp_grcl
from grscqk a
left outer join zy b on a.kh = b.kh
left outer join cpjbzl d on a.cpdm = d.cpdm
left outer join jtdm e on a.jtdm = e.jtdm
left outer join gxdm c on c.gxdm = e.ssgxdm
left outer join jtlxdm g on g.jtlxdm = e.jtlxdm
left outer join #fzb f on f.cpdm = substring(d.cpdm,1,4) and f.dy = d.dy and f.swsbsrl = d.swsbsrl and f.jtlxdm = e.jtlxdm
' + @aa
exec(@sql)
这是存储过程中的一句话，
在这段话中参数@aa = 'where rq between ''2006-09-01'' and ''2006-09-30'' and c.gxmc = ''卷绕'''
出现varchar转换成datetime时错误，请问这个要怎么处理呢？？？

...全文