GetColumnSQLVARIANTToString 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 GetColumnSQLVARIANTToString method converts a sql_variant column to a string and returns its value.
Sintaxis
object.GetColumnSQLVARIANTToString( 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 GetColumnSQLVARIANTToString(
long lRow,
long lColumn,
SQLDMO_LPCSTR ObjName,
SQLDMO_LPBSTR pRetVal);
[!NOTA]
SQL Distributed Management Objects (SQL-DMO) strings are always returned as OLE BSTR objects. A C/C++ application obtains a reference to the string. The application must release the reference using SysFreeString.
Notas
GetColumnSQLVARIANTToString can be useful in applications designed to display the contents of sql_variant columns, such as a Web site.
Columns with underlying numeric, decimal, or datetime data types cannot be converted to strings using the GetColumnSQLVARIANTToString method.
[!NOTA]
If an application calls GetColumnSQLVARIANTToString 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.