Hi...
how can I create a stored procedure from VB
@ run time not by T-sql or Data View ...
thanks 4 any advice...
Printable View
Hi...
how can I create a stored procedure from VB
@ run time not by T-sql or Data View ...
thanks 4 any advice...
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 :D
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.