Freigeben über

StoredProcedure Object

  • Artikel

Dieses Feature wird in einer zukünftigen Version von Microsoft SQL Server entfernt. Verwenden Sie dieses Feature beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.

The StoredProcedure object exposes the attributes of a single Microsoft SQL Server user-defined or system stored procedure.

SQL-DMO-Objektmodell, das das aktuelle Objekt anzeigt

Properties

AnsiNullsStatus Property

QuotedIdentifierStatus Property

CreateDate Property

Startup Property

ID Property

SystemObject Property

Name Property

Text Property

Owner Property (Database Objects)

Type Property (StoredProcedure)

Methods

Alter Method

ListPermissions Method

Deny Method (StoredProcedure)

ListUserPermissions Method

EnumDependencies Method

Remove Method (Objects)

EnumParameters Method

Revoke Method (StoredProcedure)

Grant Method (StoredProcedure, UserDefinedFunction)

Script Method

Hinweise

SQL Server has facilities for creation and persistent storage of compiled Transact-SQL scripts. These stored procedures can be run by users with sufficient permissions. With the StoredProcedure object, you can:

  • Create a SQL Server stored procedure.
  • Change the Transact-SQL script of an existing SQL Server stored procedure.
  • Enable a SQL Server stored procedure to run on SQL Server startup.
  • Control access rights to an existing SQL Server stored procedure.
  • Delete an existing SQL Server stored procedure.
  • Generate a Transact-SQL script to re-create a SQL Server stored procedure.

The Name property of a StoredProcedure object uses the SQL Server data type sysname. The value of the Name property must be unique (named by owner) within a SQL Server database.

ms133986.note(de-de,SQL.90).gifHinweis:
The StoredProcedure object is compatible with instances of SQL Server versions 7.0 and later. However, the StoredProcedure2 object extends the functionality of the StoredProcedure object for use with features that were introduced in SQL Server 2000.

To create a SQL Server stored procedure

  1. Create a StoredProcedure object.

  2. Set the Name property.

  3. Set the Text property to contain the Transact-SQL script you want. SQL Server stored procedures can contain input and output parameters and can return the results of one or more SELECT statements or a single long integer. For more information about valid Transact-SQL scripts for the Text property, see CREATE PROCEDURE (Transact-SQL).

  4. Set optional property values. For example, set the Startup property to TRUE to enable the stored procedure to run when the SQL Server starts.

  5. Add the StoredProcedure object to the StoredProcedures collection of a connected Database object.

Siehe auch

Verweis

StoredProcedure2 Object

Hilfe und Informationen

Informationsquellen für SQL Server 2005