it it possible to create/edit and save stored procedures from within vb code? im using SQL Server 2000
Printable View
it it possible to create/edit and save stored procedures from within vb code? im using SQL Server 2000
You'd use the objconn.execute method and create the SP just like you would in Enterprise manager, the exact same syntax.
Or ExecuteNonQuery on a SQLCommand object if you're using ADO.NET... :)