Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Creating, Altering, and Removing Stored Procedures

In SQL Server Management Objects (SMO), stored procedures are represented by the StoredProcedure object.

Creating a StoredProcedure object in SMO requires setting the TextBody property to the Transact-SQL script that defines the stored procedure. Parameters require the @ prefix and must be created individually by using StoredProcedureParameter objects and adding to the StoredProcedureParameter collection of the StoredProcedure object.

Community Additions

© 2015 Microsoft