INSERT OPENQUERY (oracle, 'select a, b, c, d, e, f, g the from QZJ. RECORD')
SELECT DISTINCT RTRIM (a) a, RTRIM (b) b, RTRIM (c) c, RTRIM (d) d, RTRIM (e) e, RTRIM (f) f, RTRIM (g) g
The FROM QZJ. RECORD A
WHERE SCRQ='20201003'
The oracle in the script is the name of the link to the server, now I met a problem, the script executed when is the first time a success, the implementation of the second time to quote for the following error when
Message 7353, level 16, state 1, line 20
Link server "oracle" OLE DB access interface "OraOLEDB. Oracle offers inconsistent metadata, in the process of execution provides redundant, but did not find the column at compile time,
After about 10 minutes, this went up to re-execute the success, this is why...