Creating a Stored Procedure

[blacktorncoat]

Hello,
How do I create a Stored Procedure from another program, using COM ? what is the COM method to use, and what are the arguments?

thanks,
Y.

 

[donutman]

Creating a SP is nothing more than executing the proper T-SQL commands. If you know how to submit a query in the language of choice, then you can create a SP using that language.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[ESquared]

like...

CREATE PROCEDURE ProcedureName @Variable1 datatype, @Variable2 datatype
AS
Lots of SQL statements

Then just submit that like any other query you would use, e.g. "SELECT blah FROM blah WHERE blah".

Then "ProcedureName Value1 Value2" or "EXEC ProcedureName"

-------------------------------------
• Every joy is beyond all others. The fruit we are eating is always the best fruit of all.
• It is waking that understands sleep and not sleep that understands waking. There is an ignorance of evil that comes from being young: there is a darker ignorance that comes from doing it, as men by sleeping lose the k