您所在位置：主题：请大家帮我检查一下好吗?
fuweijun
[专家分：1930] 发布于 2006-12-25 15:56:00
我想问一下我这个临时表在asp中读取值是怎么个读法呢?
Create Proc Review_All
@Incept_Id Nvarchar(50),
@Send_Id NVarchar(50),
@Review_Content NVarchar(500),
@DateTime SmallDateTime
As
Begin
Select * From Video_Review Where User_Id = @Incept_Id And Send_Id=@Send_Id And Video_Review_Content=@Review_Content And Video_Review_Time=@DateTime
End
'以下是调用
set rs=server.createobject("adodb.recordset")
sql = "exec Review_All 'snake','snake','snake','snake'"
rs.open sql,conn,3,2
response.write rs.recordcount&"<br>"
错误是:[color=FF0000]将数据类型 varchar 转换为 smalldatetime 时出错[/color]
Create Proc Review_All
@Incept_Id Nvarchar(50),
@Send_Id NVarchar(50),
@Review_Content NVarchar(500),
@DateTime SmallDateTime
As
Begin
Select * From Video_Review Where User_Id = @Incept_Id And Send_Id=@Send_Id And Video_Review_Content=@Review_Content And Video_Review_Time=@DateTime
End
'以下是调用
set rs=server.createobject("adodb.recordset")
sql = "exec Review_All 'snake','snake','snake','snake'"
rs.open sql,conn,3,2
response.write rs.recordcount&"<br>"
错误是:[color=FF0000]将数据类型 varchar 转换为 smalldatetime 时出错[/color]
