printmedia
asked on
How to call a stored procedure in an ActiveX Script in SQL Server 2000
Hi all.
I have a stored procedure that accepts a parameter for the length of time to delay and I want to use it in an ActiveX Script that is in a DTS.
How can I call this stored procedure from within an ActiveX Script?
Thank you in advance.
I have a stored procedure that accepts a parameter for the length of time to delay and I want to use it in an ActiveX Script that is in a DTS.
How can I call this stored procedure from within an ActiveX Script?
Thank you in advance.
CREATE PROCEDURE spDelay (@interval CHAR(9))
AS
WAITFOR DELAY @interval
GO
Like you execute a SQL query from ActiveX Script.
ASKER
Could you give me an example?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Why need a stored proc instead of directly calling the WAIFOR DELAY command?