I have trigger that sends data from one table to another.
I am using the Openquery statement within the trigger to send the data.
However when I Insert anything with an apostrophe into the table where the trigger resides it errors saying...
"Incorrect syntax near" where the apostrophe is and this puts out the number of Quotes in the Openquery Statement.
I use the Replace function written as REPLACE(@VARIABLE, '''', '''''') to replace One Apostrophe with 2.
I'm not sure whether I can use this with Openquery or not / or whether the syntax is correct for Replace in conjunction with OpenQuery.
If someone can give me anysight into this and any code on how to do this would be great.