techzone12
09-23-2005, 05:40 PM
The ASP code I have looks like this:
strDate = "2005-09-19"
rs.Open "my_proc " & cdate(strDate) , conn
In the stored procedure I would like to do something like:
CREATE PROCEDURE my_Proc
@DateStamp DateTime
AS
EXEC('SELECT * FROM tableName WHERE TimeStamp > '+ @DateStamp)
Obviously this doesn't work. I am getting an error like:
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
Line 1: Incorrect syntax near '/'.
Can you show me how to pass datetime from ASP to stored procedure to populate a record set?
strDate = "2005-09-19"
rs.Open "my_proc " & cdate(strDate) , conn
In the stored procedure I would like to do something like:
CREATE PROCEDURE my_Proc
@DateStamp DateTime
AS
EXEC('SELECT * FROM tableName WHERE TimeStamp > '+ @DateStamp)
Obviously this doesn't work. I am getting an error like:
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
Line 1: Incorrect syntax near '/'.
Can you show me how to pass datetime from ASP to stored procedure to populate a record set?