EnumOutputs Method
未來的 Microsoft SQL Server 版本將移除這項功能。請避免在新的開發工作中使用這項功能，並規劃修改目前使用這項功能的應用程式。
The EnumOutputs method returns a list of all output columns from a user-defined function.
語法
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. |
備註
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.
[!附註]
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.