getstring-method-int-sqlserverresultset.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	apilocation	apiname	apitype
getString Method (int) (SQLServerResultSet)	getString Method (int) (SQLServerResultSet)	David-Engel	davidengel	01/19/2017	sql	connectivity	reference	sqljdbc.jar	SQLServerResultSet.getString (int)	Assembly

getString Method (int) (SQLServerResultSet)

[!INCLUDEDriver_JDBC_Download]

Retrieves the value of the designated column index in the current row of this SQLServerResultSet object as a String in the Java programming language.

Syntax

  
public java.lang.String getString(int columnIndex)  

Parameters

columnIndex

An int that indicates the column index.

Return Value

A String value.

Exceptions

SQLServerException

Remarks

This getString method is specified by the getString method in the java.sql.ResultSet interface.

All columns in [!INCLUDEssNoVersion] can be returned as a String. This means that a String representation of all number-based and character-based types, and a hex-string representation of binary columns such as binary, varbinary, varbinary(max), image, timestamp, and uniqueidentifier, can be returned.

Location-sensitive types such as money, smallmoney, datetime, smalldatetime, float, real, decimal, and numeric will return the canonical toString() format for the underlying value of the type.

User-defined types are returned as hexadecimal String values.

See Also

getString Method (SQLServerResultSet)
SQLServerResultSet Members
SQLServerResultSet Class