EnumOutputs Method
Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.
The EnumOutputs method returns a list of all output columns from a user-defined function.
Sintaxis
object.EnumOutputs( )asQueryResults
Parts
- object
Expression that evaluates to an object in the Applies To list.
Prototype (C/C++)
HRESULT EnumOutputs(LPSQLDMOQUERYRESULTS * ppResults);
Returns
A QueryResults object that contains one result set defined by these columns.
Column |
Data type |
Description |
|---|---|---|
name |
nvarchar(129) |
Parameter name. |
name |
nvarchar(129) |
Name of the parameter data type. |
length |
smallint |
Length modifier for the parameter data type when applicable, such as in nchar(5). |
colid |
smallint |
Ordinal position of the parameter. |
Notas
When a user-defined function has no defined parameters, method execution succeeds and the result set returned is empty. The Rows property of the QueryResults object returns 0.
[!NOTA]
If an application calls EnumOutputson an instance of SQL Server version 7.0, the constant, SQLDMO_E_SQL80ONLY, and the message "This property or method requires Microsoft SQL Server 2000 or later" are returned.