Condividi tramite


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.

Vedere anche

Attività

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

Riferimento

StoredProcedure

Altre risorse

Nozioni fondamentali sulle stored procedure

Guida in linea e informazioni

Assistenza su SQL Server 2005