/**
* Execute a batch query
* @return mixed A database resource if successful, FALSE if not.
*/
function queryBatch($abort_on_error = true, $p_transaction_safe = false)
{
$this->_errorNum = 0;
$this->_errorMsg = '';
if ($p_transaction_safe) {
$si = mssql_get_server_info($this->_resource);
preg_match_all("/(\\d+)\\.(\\d+)\\.(\\d+)/i", $si, $m);
if ($m[1] >= 4) {
$this->_sql = 'START TRANSACTION;' . $this->_sql . '; COMMIT;';
} else {
if ($m[2] >= 23 && $m[3] >= 19) {
$this->_sql = 'BEGIN WORK;' . $this->_sql . '; COMMIT;';
} else {
if ($m[2] >= 23 && $m[3] >= 17) {
$this->_sql = 'BEGIN;' . $this->_sql . '; COMMIT;';
}
}
}
}
$query_split = preg_split("/[;]+/", $this->_sql);
$error = 0;
foreach ($query_split as $command_line) {
$command_line = trim($command_line);
if ($command_line != '') {
$this->_cursor = mssql_query($command_line, $this->_resource);
if (!$this->_cursor) {
$error = 1;
$this->_errorNum .= mssql_errno($this->_resource) . ' ';
$this->_errorMsg .= mssql_error($this->_resource) . " SQL={$command_line} <br />";
if ($abort_on_error) {
return $this->_cursor;
}
}
}
}
return $error ? false : true;
}
/**
* 获得数据库版本
* @return string 版本号
*/
function version()
{
return mssql_get_server_info();
}
/**
* 获取服务器信息
*
* @return string 服务器信息
*/
public function server_info()
{
return mssql_get_server_info();
}
