--- title: "getRef Method (int) (SQLServerResultSet) | Microsoft Docs" ms.custom: "" ms.date: "01/19/2017" ms.prod: sql ms.prod_service: connectivity ms.reviewer: "" ms.technology: connectivity ms.topic: conceptual apiname: - "SQLServerResultSet.getRef (int)" apilocation: - "sqljdbc.jar" apitype: "Assembly" ms.assetid: fc3f2d79-7cc3-47fa-a05e-4f7939d7f090 author: David-Engel ms.author: v-daenge --- # getRef Method (int) (SQLServerResultSet) [!INCLUDE[Driver_JDBC_Download](../../../includes/driver_jdbc_download.md)] Retrieves the value of the designated column index in the current row of this [SQLServerResultSet](../../../connect/jdbc/reference/sqlserverresultset-class.md) object as a Ref object in the Java programming language. ## Syntax ``` public java.sql.Ref getRef(int i) ``` #### Parameters *i* An **int** that indicates the column index. ## Return Value A Ref object. ## Exceptions [SQLServerException](../../../connect/jdbc/reference/sqlserverexception-class.md) ## Remarks This getRef method is specified by the getRef method in the java.sql.ResultSet interface. ## See Also [getRef Method (SQLServerResultSet)](../../../connect/jdbc/reference/getref-method-sqlserverresultset.md) [SQLServerResultSet Members](../../../connect/jdbc/reference/sqlserverresultset-members.md) [SQLServerResultSet Class](../../../connect/jdbc/reference/sqlserverresultset-class.md)