Results 1 to 3 of 3

Thread: Create Stored Procedure ?

  1. Apr 2nd, 2000, 01:15 PM #1
    BlackRose
    BlackRose is offline

    Thread Starter
    Member
    Join Date
    Sep 1999
    Location
    Lebanon, Beirut
    Posts
    63
    Hi...
    how can I create a stored procedure from VB
    @ run time not by T-sql or Data View ...
    thanks 4 any advice...
    What U know is more important than where and how U learned it.
    Reply With Quote Reply With Quote
  2. Apr 2nd, 2000, 01:19 PM #2
    Gen-X
    Gen-X is offline
    Hyperactive Member
    Join Date
    Mar 2000
    Posts
    461
    As far as I know there isn't a way of creating a stored procedure at run-time...

    The main reason for this is that a stored procedure has to be "compiled", it needs to make sure the database tables exist, it runs query plans and then creates the internal code required to make it run.

    Thats the whole point of stored procedures so doing them at run-time kind of defeats the purpose.

    I might be wrong though... always open to enlightenment
    Reply With Quote Reply With Quote
  3. Apr 2nd, 2000, 11:04 PM #3
    HDR
    HDR is offline
    Addicted Member
    Join Date
    Jan 2000
    Location
    Fresno, California, USA
    Posts
    195
    I believe you can by executing the scripts to create the stored procedure from your program. But I can't understand why you would want to do that. It would really slow the process down. You can pass variables along with the stored procedure name to the data base to make the SP dynamic. However, my experience is with SQL-Server, not Access.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width