高考问答年轻人摆地摊卖小吃:sql 存储过程日期错误?
来源：百度文库 编辑：高考问答 时间：2024/05/01 14:13:24
CREATE PROCEDURE down_list_update
(
@case char(20),
@tdate smalldatetime,
@plus_down_download_id char(10)
)
AS
declare @sql char(900)
if @case = '3'
update [plus_down_download] set dayhits=dayhits+1 ,lasthits= @tdate where id =@plus_down_download_id
GO
ASP调用:
tdate=year(Now()) & "-" & month(Now()) & "-" & day(Now())
conn.Execute("down_list_update 3," & tdate & "," & cint(request("id")))
IE提示
'-' 附近有语法错误。
为什么?
(
@case char(20),
@tdate smalldatetime,
@plus_down_download_id char(10)
)
AS
declare @sql char(900)
if @case = '3'
update [plus_down_download] set dayhits=dayhits+1 ,lasthits= @tdate where id =@plus_down_download_id
GO
ASP调用:
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")))