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.

Siehe auch

Aufgaben

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

Verweis

StoredProcedure

Andere Ressourcen

Grundlagen der gespeicherten Prozeduren

Hilfe und Informationen

Informationsquellen für SQL Server 2005