ColumnType Property

Esse recurso será removido em uma versão futura do Microsoft SQL Server. Evite usar esse recurso em desenvolvimentos novos e planeje modificar os aplicativos que atualmente o utilizam.

The ColumnType property returns the base data type of a column in the current result set of a QueryResults object.

Sintaxe

object
.ColumnType(
OrdinalColumn
)

Parts

• object
  An expression that evaluates to an object in the Applies To list

• OrdinalColumn
  A long integer that specifies the column in the results by position

Data Type

Long, enumerated

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetColumnType(long nColumn,
SQLDMO_QUERY_DATATYPE* pRetVal);

Returns

The value returned by ColumnType is evaluated using these SQLDMO_QUERY_DATATYPE values.

Constant	Value	Description
SQLDMO_DtypeBigint	-5	bigint data type.
SQLDMO_DTypeBinary	-2	Fixed length binary data.
SQLDMO_DTypeBit	-7	Unsigned integer data. The width of the integer is one byte.
SQLDMO_DTypeChar	1	Fixed length character.
SQLDMO_DTypeDateTime	-2	ODBC SQL_TIMESTAMP_STRUCT.
SQLDMO_DTypeDateTime4	93	ODBC SQL_TIMESTAMP_STRUCT.
SQLDMO_DTypeFloat4	7	Approximate numeric data. The width of the numeric value is four bytes.
SQLDMO_DTypeFloat8	8	Approximate numeric data. The width of the numeric value is eight bytes.
SQLDMO_DTypeGUID	-11	Globally unique identifier (GUID). The data is a data structure 16 bytes in length.
SQLDMO_DTypeImage	-4	Long, variable length binary data.
SQLDMO_DTypeInt1	-6	Unsigned integer data. The width of the integer is one byte.
SQLDMO_DTypeInt2	5	Signed integer data. The width of the integer is two bytes.
SQLDMO_DTypeInt4	4	Signed integer data. The width of the integer is four bytes.
SQLDMO_DTypeMoney	3	Scaled integer data represented as a string value.
SQLDMO_DTypeMoney4	3	Scaled integer data represented as a string value.
SQLDMO_DTypeNText	-10	Long, variable length, Unicode character data.
SQLDMO_DTypeSQLVariant	-150	sql_variant data type.
SQLDMO_DTypeText	-1	Long, variable length character data.
SQLDMO_DTypeUChar	-8	Fixed length, Unicode character data.
SQLDMO_DTypeUnknown	0	A data type value that is unsupported or not valid.
SQLDMO_DTypeUVarchar	-9	Variable length, Unicode character data.
SQLDMO_DTypeVarBinary	-3	Variable length binary data.
SQLDMO_DTypeVarchar	12	Variable length character data.

Applies To:

QueryResults Object