SQL server to create the oracle odbc connections, query language sentence when
SELECT * from OPENQUERY (ORACLE, 'SELECT * from m_pur')
Display only a data, but the same statement, some tables and display all the data again, is what reason, ask god for help

CodePudding user response:

Try less choose some fields, such as queries only primary key columns,

CodePudding user response:

reference 1st floor wmxcn2000 response:

try little choose some fields, such as the query only primary key columns,

Only the primary key column is the same one line of data