How to avoid a syntax error on this UPDATE statement..??
Posted on 2011-10-22
I'm running the following SQL statement and I'm getting a syntax error...
UPDATE Global_Response_Fields SET Timestamp='2011-10-22T08:50:34Z', CorrelationID='f1833aed8eeef'
If I remove the Timestamp value from the update then it works fine, but I'm not sure what about that value is causing me a problem or how to fix it..?? It's just a regular text field that I'm trying to add that string of text into.
Any information on how I can fix this would be greatly appreciated. Thanks!