t-sql, get column number in the table code example
Example: how to get column count
/**
* Get the column count
* @return count of column the result set have
*/
public static int getColumnCount(){
int columnCount = 0;
try {
ResultSetMetaData rsMetaData = rs.getMetaData();
columnCount = rsMetaData.getColumnCount();
} catch (SQLException e) {
System.out.println("ERROW WHILE GETTING COLUMN COUNT " +e.getMessage());
}
return columnCount;
}