Freigeben über


EnumMatchingSPs Method

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 EnumMatchingSPs method returns a QueryResults object that enumerates the stored procedures that contain the specified search text.

Syntax

object
.EnumMatchingSPs(
Text
, [ IncSys ] )as QueryResults

Parts

  • object
    Expression that evaluates to an object in the Applies To list.
  • Text
    String that specifies search text.
  • IncSys
    TRUE or FALSE.

Prototype (C/C++)

HRESULT EnumMatchingSPs(
LPCOLESTR Text,
LPSQLDMOQUERYRESULTS * ppResults,
BOOL IncSys CPPDEFAULT (= FALSE));

Returns

A QueryResults object that contains one result set defined by this column.

Column Data type Description

name

nchar(129)

Name of the stored procedure.

Hinweise

When IncSys is TRUE, system and user-defined stored procedures are enumerated in the QueryResults object.

When IncSys is FALSE (default), only user-defined stored procedures are enumerated in the QueryResults object.

Applies To:

Database Object