Retrieves the value of the designated parameter as a string in the Java programming language given the parameter index.

public java.lang.String getString(int index)

Parameters

index

An integer that indicates the parameter index.

Return Value

A string value.

Exceptions

SQLServerException

Remarks

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

All columns in SQL Server 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