日期:2014-05-18  浏览次数:20593 次

嘿嘿 大虾门解决下呵呵
shijian= "2007-6-12 "

我想把这个时间shijian   更新到JC_UserSalary_Days中
但是直接从查询中没有只有冲asp的参数中得到


SQL= "INSERT   INTO   JC_UserSalary_Days(UserName,Tbianma,ZZ,CreateDate)”
SQL=SQL   &   "   Select     b.username   ,   B.Tbianma,b.zz,   (这个地方怎么弄时间) "
SQL=SQL   &   "   from   (select   ......)   as   b "



------解决方案--------------------
shijian= "2007-6-12 "
SQL= "INSERT INTO JC_UserSalary_Days(UserName,Tbianma,ZZ,CreateDate)”
SQL=SQL & " Select b.username , B.Tbianma,b.zz, "
SQL=SQL & shijian
SQL=SQL & " from (select ......) as b "

------解决方案--------------------
--时间要用 ' '扩起来

shijian= "2007-6-12 "
SQL= "INSERT INTO JC_UserSalary_Days(UserName,Tbianma,ZZ,CreateDate)”
SQL=SQL & " Select b.username , B.Tbianma,b.zz, "
SQL=SQL & " ' " & shijian & " ' "
SQL=SQL & " from (select ......) as b "