S
Stan Sainte-Rose
Hi,
How to update a stored procedure from Vb.net ?
Stan
How to update a stored procedure from Vb.net ?
Stan
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Miha Markic
Change its declaration?
You will have to invoke sql stataments to do it.
You will have to invoke sql stataments to do it.
S
Stan Sainte-Rose
In fact, sometimes, I have to update some Sproc and I use Sql Server
Enterprise Manager.
So, I would like to do it using my vb application.. but don't know how to do
it...
Enterprise Manager.
So, I would like to do it using my vb application.. but don't know how to do
it...
M
Miha Markic
Use SqlCommand.
Set the CommandText to "ALTER bla bla " and ExecuteNonQuery().
Set the CommandText to "ALTER bla bla " and ExecuteNonQuery().
C
Cowboy \(Gregory A. Beamer\)
Looking at the rest of this thread, it appears you are familiar with
Enterprise Manager, which is a good spot to alter your procs. You can
certainly alter them from code, using the DDL statement ALTER PROCEDURE,
followed by the entire header and body of the sproc.
If you are attempting to create a tool for this, I can see where you are
going. If you are altering sprocs based on application logic, that is not
wise. Sprocs should be solid when a product is released.
NOTE: Depending on the version of Visual Studio .NET used, you can alter
sprocs directly in the VS.NET IDE using the database tools.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
**********************************************************************
Think Outside the Box!
**********************************************************************
Enterprise Manager, which is a good spot to alter your procs. You can
certainly alter them from code, using the DDL statement ALTER PROCEDURE,
followed by the entire header and body of the sproc.
If you are attempting to create a tool for this, I can see where you are
going. If you are altering sprocs based on application logic, that is not
wise. Sprocs should be solid when a product is released.
NOTE: Depending on the version of Visual Studio .NET used, you can alter
sprocs directly in the VS.NET IDE using the database tools.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
**********************************************************************
Think Outside the Box!
**********************************************************************