Partager via


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.

Voir aussi

Tâches

How to: Create, Alter, and Remove a Stored Procedure in Visual Basic .NET

Référence

StoredProcedure

Autres ressources

Présentation des procédures stockées

Aide et Informations

Assistance sur SQL Server 2005