http://www.brentozar.com/archive/2009/09/whats-on-my-bookshelf/
rc = SQLSetStmtOption(hstmt, SQL_ROWSET_SIZE, 100); /* Use arrays of 100 elements */ rc = SQLExecDirect(hstmt, "SELECT <20 columns> FROM employees " + "WHERE HireDate >= ?", SQL_NTS); /* Call SQLBindCol one time specifying row-wise binding */ do { rc = SQLExtendedFetch(hstmt, SQL_FETCH_NEXT, 0, &RowsFetched, RowStatus); } while ((rc == SQL_SUCCESS) || (rc == SQL_SUCCESS_WITH_INFO));













