public static function query($queryStr = '', $objectStr = '')
 {
     $queryDB = mssql_query(self::$dbConnect, $queryStr);
     if (preg_match('/insert into/i', $queryDB)) {
         mssql_next_result($queryDB);
         $row = mssql_fetch_row($queryDB);
         self::$insertID = $row[0];
     }
     if (is_object($objectStr)) {
         $objectStr($queryDB);
     }
     return $queryDB;
 }

 /**
  * Move the internal result pointer to the next available result
  *
  * @return true on success, false if there is no more result set or an error object on failure
  * @access public
  */
 function nextResult()
 {
     if ($this->result === false) {
         return $this->db->raiseError(MDB2_ERROR_NEED_MORE_DATA, null, null, 'resultset has already been freed', __FUNCTION__);
     } elseif (is_null($this->result)) {
         return false;
     }
     return @mssql_next_result($this->result);
 }

 /**
  * @see CallableStatement::getMoreResults()
  */
 function getMoreResults()
 {
     $this->rsFetchCount++;
     // we track this because
     $hasMore = mssql_next_result($this->result);
     if ($this->resultSet) {
         $this->resultSet->close();
     }
     if ($hasMore) {
         $clazz = $this->resultClass;
         $this->resultSet = new $clazz($this, $this->result);
     } else {
         $this->resultSet = null;
     }
     return $hasMore;
 }

 /**
  * Move the internal result pointer to the next available result
  * Currently not supported
  *
  * @return true if a result is available otherwise return false
  * @access public
  */
 function nextResult()
 {
     if (is_null($this->result)) {
         return $this->mdb->raiseError(MDB2_ERROR_NEED_MORE_DATA, null, null, 'nextResult: resultset has already been freed');
     }
     return @mssql_next_result($this->result);
 }

 public function sqlReport($sQuery)
 {
     if (!preg_match('/^SELECT/', $sQuery)) {
         return '';
     }
     $bTable = false;
     $sHtml = '';
     @mssql_query('SET SHOWPLAN_TEXT ON;', $this->_hMaster);
     if ($hResult = @mssql_query($sQuery, $this->_hMaster)) {
         @mssql_next_result($hResult);
         while ($aRow = @mssql_fetch_row($hResult)) {
             list($bTable, $sData) = Phpfox_Debug::addRow($bTable, $aRow);
             $sHtml .= $sData;
         }
     }
     @mssql_query('SET SHOWPLAN_TEXT OFF;', $this->_hMaster);
     @mssql_free_result($hResult);
     if ($bTable) {
         $sHtml .= '</table>';
     }
     return $sHtml;
 }

 /**
  * 把查询数据库的指针移到下一条记录
  * 
  * @return array
  */
 function nextRecord()
 {
     $this->Record = array();
     mssql_next_result($this->queryId);
     $this->Record = mssql_fetch_array($this->queryId);
     $result = $this->Record;
     if (!is_array($result)) {
         return $this->Record;
     }
     foreach ($result as $key => $value) {
         $keylower = strtolower($key);
         if ($keylower != $key) {
             $this->Record[$keylower] = $value;
         }
     }
     return $this->Record;
 }

 /**
  * method to deal with the execution of MS SQL stored proceedured
  * @param $string $procName The name of the proceedure to execute
  * @param array $paramArray An array containing entries for each paramneeded but the stored proceedure see the exampel in the code below
  */
 function exeStoredProc($procName, $paramArray = false, $skip_results = false)
 {
     // example param array
     // $paramArray = array ('LocationName' => array ('VALUE' => 'the clients host name', 'TYPE' => 'SQLVARCHAR', 'ISOUTPUT' => 'false', 'IS_NULL' =>'false', 'MAXLEN' => '255' ) );
     // each element in the paramArray must idetify a paramiter required by the stored proceedure and can tain an array of settings from that paramiter
     // see http://php.net/manual/en/function.mssql-bind.php for information on the values for these paramiters
     // initiate the stored proceedure
     $stmt = mssql_init($procName, $this->linkid);
     // bind paramiters
     if ($paramArray) {
         foreach ($paramArray as $paramName => $values) {
             mssql_bind($stmt, $paramName, $values['VALUE'], $values['TYPE'], $values['ISOUTPUT'], $values['IS_NULL'], $values['MAXLEN']);
         }
     }
     // execute the stored proceedure
     $results = mssql_execute($stmt);
     // if we do not get anu results return false
     if (!$results) {
         return false;
         // if we get results then put them in to an array and return it
     } else {
         // define the array to return
         $resultArray = array();
         // loop throught he result set and place each result to the resultArray
         do {
             while ($row = mssql_fetch_row($stmt)) {
                 $resultArray[] = $row;
             }
         } while (mssql_next_result($stmt));
         // clean up the statment ready for the next useexec SELLING_GetLocation @LocationName='it-leigh.skilouise.com'
         mssql_free_statement($stmt);
         //returnt he result array
         return $resultArray;
     }
 }

 function NextRecordSet()
 {
     if (!mssql_next_result($this->_queryID)) {
         return false;
     }
     $this->_inited = false;
     $this->bind = false;
     $this->_currentRow = -1;
     $this->Init();
     return true;
 }

 /**
  * Move the internal result pointer to the next result
  * 
  * @param	resource	$statement - The result resource that is being evaluated.
  * @return	boolean
  */
 public function nextResult($statement)
 {
     if (!is_resource($statement)) {
         throw new LikePDOException("There is no active statement");
         return false;
     } else {
         return mssql_next_result($statement);
     }
 }

 function GetResults()
 {
     $out = array();
     do {
         while ($row = mssql_fetch_assoc($this->Result)) {
             $out[] = $row;
         }
     } while (mssql_next_result($this->Result));
     return $out;
 }

 /**
  * 把查询数据库的指针移到下一条记录
  *
  * @return array
  */
 public function nextRecord()
 {
     mssql_next_result($this->queryId);
     return mssql_fetch_array($this->queryId);
 }

SET @limit = 20
SET @offset = 4
OPEN Search
FETCH ABSOLUTE @offset FROM Search
WHILE @@FETCH_STATUS =0 AND @limit > 1
BEGIN
  FETCH NEXT FROM Search
  SET @limit = @limit -1
END
CLOSE Search
DEALLOCATE Search
EOSQL;
$num_rows = 0;
$res = mssql_query($sql) or die("query");
$row = mssql_fetch_assoc($res);
while ($row) {
    ++$num_rows;
    //  print_r($row);
    echo "got a row, name is {$row['name']}\n";
    $row = mssql_fetch_assoc($res);
    if (!$row) {
        if (mssql_next_result($res)) {
            $row = mssql_fetch_assoc($res);
        }
    }
}
if ($num_rows < 2) {
    echo "Expected more than a row\n";
    exit(1);
}
exit(0);

 /**
  * 向下移动一个数据集 Move the internal result pointer to the next result
  *
  * @return boolean The function will return TRUE if an additional result set was available or FALSE otherwise.
  */
 public function next_result()
 {
     if (!is_resource($this->result)) {
         return false;
     }
     mssql_next_result($this->result);
 }

 /**
  * Retrieves the next rowset (result set) for a SQL statement that has
  * multiple result sets.  An example is a stored procedure that returns
  * the results of multiple queries.
  *
  * @return bool
  * @throws Zend_Db_Statement_Exception
  */
 public function nextRowset()
 {
     if (mssql_next_result($this->_result) === false) {
         throw new Zend_Db_Statement_Exception(mssql_get_last_message());
     }
     // reset column keys
     $this->_keys = null;
     return true;
 }

function func_mssql_query($query, $sess, &$bin, &$biVal, &$biLen, &$biRes, &$biType)
{
    if (count($bin) >= 1) {
        $res = mssql_init($query);
        for ($i = 0; $i < count($bin); $i++) {
            $TypeParam = TRUE;
            $biRes[$i] = $biVal[$i];
            if ($biLen[$i] == -1) {
                $TypeParam = FALSE;
            }
            if ($biType[$i] == 1) {
                $msType = SQLVARCHAR;
            }
            if ($biType[$i] == 2) {
                $msType = SQLINT4;
            }
            if ($biType[$i] == 3) {
                $msType = SQLFLT8;
            }
            if ($biType[$i] == 4) {
                $msType = SQLVARCHAR;
            }
            mssql_bind($res, $bin[$i], $biRes[$i], $msType, $TypeParam);
        }
        $resExec = mssql_execute($res);
        while (mssql_next_result($resExec)) {
        }
    } else {
        $resExec = mssql_query($query);
        if (!$resExec) {
            ErreurExecutionMSSQL();
        }
    }
    return $resExec;
}

$num_res = 0;
$stmt = mssql_init("sp_php_test", $conn);
$rs = mssql_execute($stmt);
if (is_resource($rs)) {
    echo "fetching...\n";
    do {
        ++$num_res;
        echo "Processing result {$num_res}\n";
        echo "Num rows = " . mssql_num_rows($rs) . "\n";
        if (!$err && $num_res == 1 && mssql_num_rows($rs) != 0) {
            $err = "Expected 0 rows from recordset {$num_res}";
        }
        if (!$err && $num_res == 2 && mssql_num_rows($rs) != 2) {
            $err = "Expected 2 rows from recordset {$num_res}";
        }
        // Process result
    } while (mssql_next_result($rs));
    mssql_free_result($rs);
}
if (!$err && $num_res != 2) {
    $err = "Expected 2 resultset got {$num_res}";
}
# cleanup
mssql_query("drop proc sp_php_test");
mssql_query("drop table php_test");
mssql_close($conn);
if ($err) {
    echo "{$err}\n";
    exit(1);
}
exit(0);

 /**
  * Build db-specific report
  * @access private
  */
 function _sql_report($mode, $query = '')
 {
     switch ($mode) {
         case 'start':
             $html_table = false;
             @mssql_query('SET SHOWPLAN_TEXT ON;', $this->db_connect_id);
             if ($result = @mssql_query($query, $this->db_connect_id)) {
                 @mssql_next_result($result);
                 while ($row = @mssql_fetch_row($result)) {
                     $html_table = $this->sql_report('add_select_row', $query, $html_table, $row);
                 }
             }
             @mssql_query('SET SHOWPLAN_TEXT OFF;', $this->db_connect_id);
             @mssql_free_result($result);
             if ($html_table) {
                 $this->html_hold .= '</table>';
             }
             break;
         case 'fromcache':
             $endtime = explode(' ', microtime());
             $endtime = $endtime[0] + $endtime[1];
             $result = @mssql_query($query, $this->db_connect_id);
             while ($void = @mssql_fetch_assoc($result)) {
                 // Take the time spent on parsing rows into account
             }
             @mssql_free_result($result);
             $splittime = explode(' ', microtime());
             $splittime = $splittime[0] + $splittime[1];
             $this->sql_report('record_fromcache', $query, $endtime, $splittime);
             break;
     }
 }

 /**
  * return the result of the last query.
  * @param mixed $idname if $idname is false keys are simply incrementing from 0, if $idname is string the key is the value of the column specified in the string
  */
 private function &lastResult($idnames = false)
 {
     do {
         $result = array();
         if (@mssql_num_rows($this->result) > 0) {
             if ($idnames === false) {
                 while ($row = mssql_fetch_assoc($this->result)) {
                     $result[] = $row;
                 }
             } else {
                 while ($row = mssql_fetch_assoc($this->result)) {
                     $current =& $result;
                     foreach ($idnames as $idname) {
                         if (!array_key_exists($idname, $row)) {
                             throw new InvalidArgumentException('Cant order result by a field thats not in the resultset (forgot to select it?)');
                         }
                         if ($row[$idname] === null) {
                             $row[$idname] = 'null';
                         }
                         $current =& $current[$row[$idname]];
                     }
                     $current = $row;
                 }
                 //while
             }
             //idnames!=false
         }
         //num_rows>0
     } while (mssql_next_result($this->result));
     return $result;
 }

 /**
  * Move the internal mssql result pointer to the next available result
  *
  * @param a valid fbsql result resource
  *
  * @access public
  *
  * @return true if a result is available otherwise return false
  */
 function nextResult($result)
 {
     return @mssql_next_result($result);
 }

 /**
  * Build db-specific report
  * @access: private
  */
 function _sql_report($mode, $query = '')
 {
     switch ($mode) {
         case 'start':
             $explain_query = $query;
             if (preg_match('/UPDATE ([a-z0-9_]+).*?WHERE(.*)/s', $query, $m)) {
                 $explain_query = 'SELECT * FROM ' . $m[1] . ' WHERE ' . $m[2];
             } else {
                 if (preg_match('/DELETE FROM ([a-z0-9_]+).*?WHERE(.*)/s', $query, $m)) {
                     $explain_query = 'SELECT * FROM ' . $m[1] . ' WHERE ' . $m[2];
                 }
             }
             if (preg_match('/^SELECT/', $explain_query)) {
                 $html_table = false;
                 @mssql_query("SET SHOWPLAN_TEXT ON;", $this->db_connect_id);
                 if ($result = @mssql_query($explain_query, $this->db_connect_id)) {
                     @mssql_next_result($result);
                     while ($row = @mssql_fetch_row($result)) {
                         $html_table = $this->sql_report('add_select_row', $query, $html_table, $row);
                     }
                 }
                 @mssql_query("SET SHOWPLAN_TEXT OFF;", $this->db_connect_id);
                 @mssql_free_result($result);
                 if ($html_table) {
                     $this->html_hold .= '</table>';
                 }
             }
             break;
         case 'fromcache':
             $endtime = explode(' ', microtime());
             $endtime = $endtime[0] + $endtime[1];
             $result = @mssql_query($query, $this->db_connect_id);
             while ($void = @mssql_fetch_assoc($result)) {
                 // Take the time spent on parsing rows into account
             }
             @mssql_free_result($result);
             $splittime = explode(' ', microtime());
             $splittime = $splittime[0] + $splittime[1];
             $this->sql_report('record_fromcache', $query, $endtime, $splittime);
             break;
     }
 }