遍历局域网下所有主机的SQL Server数据库并汇总到一台主机上 给出C++具体代码

这个问题需要使用操作系统相关的API来实现。以下是一个基于Windows API的C++代码示例，可以遍历局域网下所有主机的SQL Server数据库并汇总到一台主机上：

#include <windows.h>
#include <sqlext.h>
#include <iostream>
#include <vector>
using namespace std;

// 定义存储SQL Server实例信息的结构体
struct SqlInstanceInfo {
    string serverName;
    string instanceName;
    string version;
};

// 定义存储数据库信息的结构体
struct DatabaseInfo {
    string serverName;
    string instanceName;
    string databaseName;
};

// 获取局域网内所有SQL Server实例的信息
vector<SqlInstanceInfo> GetAllSqlInstances() {
    vector<SqlInstanceInfo> instanceList;
    SQLHANDLE henv = NULL;
    SQLHANDLE hdbc = NULL;
    SQLHANDLE hstmt = NULL;
    SQLCHAR outstr[1024];
    SQLSMALLINT outstrlen;

    SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &henv);
    SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION, (SQLPOINTER) SQL_OV_ODBC3, 0);
    SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc);

    SQLCHAR szConnStrOut[1024];
    SQLSMALLINT cbConnStrOut = 0;
    SQLCHAR szConnStrIn[] = "Driver={SQL Server}; Server=(local); Trusted_Connection=Yes;";

    SQLRETURN retcode;
    retcode = SQLDriverConnect(hdbc, NULL, szConnStrIn, SQL_NTS, szConnStrOut, 1024, &cbConnStrOut, SQL_DRIVER_NOPROMPT);

    SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt);
    SQLCHAR *query = (SQLCHAR *)"SELECT SERVERPROPERTY('MachineName'), SERVERPROPERTY('InstanceName'), @@VERSION";
    SQLExecDirect(hstmt, query, SQL_NTS);

    SQLBindCol(hstmt, 1, SQL_C_CHAR, outstr, sizeof(outstr), &outstrlen);
    SQLBindCol(hstmt, 2, SQL_C_CHAR, outstr + 256, sizeof(outstr) - 256, &outstrlen);
    SQLBindCol(hstmt, 3, SQL_C_CHAR, outstr + 512, sizeof(outstr) - 512, &outstrlen);

    while (SQLFetch(hstmt) != SQL_NO_DATA) {
        SqlInstanceInfo instanceInfo;
        instanceInfo.serverName = (char *)outstr;
        instanceInfo.instanceName = (char *)(outstr + 256);
        instanceInfo.version = (char *)(outstr + 512);
        instanceList.push_back(instanceInfo);
    }

    SQLFreeHandle(SQL_HANDLE_STMT, hstmt);
    SQLDisconnect(hdbc);
    SQLFreeHandle(SQL_HANDLE_DBC, hdbc);
    SQLFreeHandle(SQL_HANDLE_ENV, henv);

    return instanceList;
}

// 获取指定SQL Server实例下的所有数据库信息
vector<DatabaseInfo> GetAllDatabases(string serverName, string instanceName) {
    vector<DatabaseInfo> dbList;
    SQLHANDLE henv = NULL;
    SQLHANDLE hdbc = NULL;
    SQLHANDLE hstmt = NULL;
    SQLCHAR outstr[1024];
    SQLSMALLINT outstrlen;

    SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &henv);
    SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION, (SQLPOINTER) SQL_OV_ODBC3, 0);
    SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc);

    string connectionString = "Driver={SQL Server}; Server=" + serverName + "\\" + instanceName + "; Trusted_Connection=Yes;";
    SQLCHAR szConnStrOut[1024];
    SQLSMALLINT cbConnStrOut = 0;
    SQLCHAR *szConnStrIn = (SQLCHAR *)connectionString.c_str();

    SQLRETURN retcode;
    retcode = SQLDriverConnect(hdbc, NULL, szConnStrIn, SQL_NTS, szConnStrOut, 1024, &cbConnStrOut, SQL_DRIVER_NOPROMPT);

    SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt);
    SQLCHAR *query = (SQLCHAR *)"SELECT name FROM sys.databases WHERE name NOT IN ('master', 'tempdb', 'model', 'msdb')";
    SQLExecDirect(hstmt, query, SQL_NTS);

    SQLBindCol(hstmt, 1, SQL_C_CHAR, outstr, sizeof(outstr), &outstrlen);

    while (SQLFetch(hstmt) != SQL_NO_DATA) {
        DatabaseInfo dbInfo;
        dbInfo.serverName = serverName;
        dbInfo.instanceName = instanceName;
        dbInfo.databaseName = (char *)outstr;
        dbList.push_back(dbInfo);
    }

    SQLFreeHandle(SQL_HANDLE_STMT, hstmt);
    SQLDisconnect(hdbc);
    SQLFreeHandle(SQL_HANDLE_DBC, hdbc);
    SQLFreeHandle(SQL_HANDLE_ENV, henv);

    return dbList;
}

int main() {
    vector<SqlInstanceInfo> instanceList = GetAllSqlInstances();
    vector<DatabaseInfo> dbList;

    for (auto instanceInfo : instanceList) {
        vector<DatabaseInfo> dbListForInstance = GetAllDatabases(instanceInfo.serverName, instanceInfo.instanceName);
        dbList.insert(dbList.end(), dbListForInstance.begin(), dbListForInstance.end());
    }

    // 处理所有数据库信息
    for (auto dbInfo : dbList) {
        cout << "Server: " << dbInfo.serverName << "\\" << dbInfo.instanceName << ", Database: " << dbInfo.databaseName << endl;
    }

    return 0;
}

以上代码可以获取局域网内所有SQL Server实例的信息，并遍历每个实例下的所有数据库，最终将所有数据库信息汇总到一起。请注意，此代码仅适用于Windows操作系统，并需要安装SQL Server ODBC驱动程序。如果使用其他操作系统或数据库，代码需要进行相应的修改。