Viewing 3 posts - 1 through 4 (of 4 total)
No. Nothing leads me to a valid answer. In the end, I've adopted the following syntax (a bit complex with lot of parameters)
SET @SQL_Cmd = 'EXECUTE (''INSERT INTO EntityMaster (id,...
April 14, 2015 at 6:35 am
My initial suspect was that OPENQUERY delays or uses a local cache. When I found that Master record was inserted in MySQL table I cannot explain why foreign key check...
March 6, 2015 at 7:28 am
Yes, with a SELECT * FROM OPENQUERY(EXTSYS, 'SELECT * FROM EntityMaster WHERE id=131177') put between first and second INSERT, I can see inserted row (that makes me crazy :crazy: ).
Even...
March 6, 2015 at 7:05 am
Viewing 3 posts - 1 through 4 (of 4 total)