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.