sql 存储过程日期错误?
CREATE PROCEDURE down_list_update(@case char(20),@tdate smalldatetime,@plus_down_download_id char(10))ASdeclare @sql char(900)if @case = '3'update [plus_down_download] set dayhits=dayhits+1 ,lasthits= @tdate where id =@plus_down_download_idGOASP调用:tdate=year(Now()) & "-" & month(Now()) & "-" & day(Now())conn.Execute("down_list_update 3," & tdate & "," & cint(request("id")))IE提示'-' 附近有语法错误。为什么?
参考答案:在SQL SERVER里,日期传值需要加“'”,如:
conn.Execute("down_list_update 3," & tdate & "," & cint(request("id")))
改为:
conn.Execute("down_list_update 3,'" & tdate & "'," & cint(request("id")))