GetColumnSQLVARIANTDataType Method
この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。新規の開発作業ではこの機能を使用しないようにし、現在この機能を使用しているアプリケーションは修正することを検討してください。
The GetColumnSQLVARIANTDataType method retrieves the underlying data type of the specified sql_variant column.
構文
object
.GetColumnSQLVARIANTDataType(
Row
,
Column
,
ObjName
)
as String
Parts
- object
Expression that evaluates to an object in the Applies To list.
- Row
Long integer that identifies a row by ordinal position.
- Column
Long integer that identifies a column by ordinal position.
- ObjName
String that specifies a table or view name.
Prototype (C/C++)
HRESULT GetColumnSQLVARIANTDataType(
long lRow,
long lColumn,
SQLDMO_LPCSTR ObjName,
SQLDMO_LPBSTR pRetVal);
.gif "ms134979.note(ja-jp,SQL.90).gif") メモ : |
|---|
| SQL Distributed Management Objects (SQL-DMO) strings are returned as OLE BSTR objects. A C/C++ application obtains a reference to the string. The application must release the reference using SysFreeString. |
解説
An application written in C++ can use the information returned by the GetColumnSQLVARIANTDataType and GetColumnSQLVARIANTLength methods to allocate an appropriate amount of buffer space in which to manipulate the data retrieved from a sql_variant column.
The application can then call GetColumnSQLVARIANT to return the contents of a sql_variant column as an array. The application can then cast the contents of the array into the required data type.
| メモ : |
|---|
| If an application calls GetColumnSQLVARIANTDataType on 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. |
Applies To:
参照
関連項目
GetColumnSQLVARIANT Method
GetColumnSQLVARIANTLength Method