Re: Convert string to Number

From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 03/15/04 

Date: Mon, 15 Mar 2004 23:34:59 +0530

hi ricky,

once you create stored procedure it gets created in the database. No need to run the "create
procedure...." statement again, all you have to do is execute stored procedure through "asp".
You will have to look for exact syntax which will execute the stored procedure. you can also
take help of newsgroups like "microsoft.public.vb" whereby you will get ample of help about
executing "stored procedure" through aps/vb code. 

-- 
Vishal Parkar
vgparkar@yahoo.co.in

Relevant Pages

  • Re: Execute stored procedure only
    ... You need CONNECT capability to be able to get into the database and execute ... You can compare this to having permission to eat a piece of pie, ... Should I not be able to just execute SP through QA? ... right to execute stored procedure in database called "mydatabase". ...
    (microsoft.public.sqlserver.security)
  • RE: SQL stored procedure executing twice
    ... I wasn't aware that DLookupwould execute the "domain" more than once. ... caused the stored procedure to execute twice. ... Dim stDocName As String ... My pass-thru query properties ...
    (microsoft.public.access.modulesdaovba)
  • Could not find stored procedure error
    ... I can execute a select query on a database but ... I get an error when I try to execute a stored procedure. ... database which is preventing it from finding my stored procedures. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQLserver and the WHERE x IN y
    ... to a stored procedure - that would only work if you introduced subtyping into ... the temp table from the calling procedure (the temp table is still in scope, ... INSERT INTO #MyTempTable EXECUTE YourPopulateProc 123 ... INSERT INTO @MyTableVar VALUES ...
    (microsoft.public.sqlserver.programming)
  • RE: SQL stored procedure executing twice
    ... caused the stored procedure to execute twice. ... from one parent record to another. ... Dim stDocName As String ... The table tempCount does not change until I execute the VBA code line: ...
    (microsoft.public.access.modulesdaovba)