One of the people where I work did a migration from Access to SQL Server and just about everything migrated okay. However, all of the UPDATE and DELETE queries, when they were migrated, ended up having the "`" character interspersed throughout the query, which causes errors when trying to run the queries in SQL Server. That's the backtick character, the one underneath the ~ on the keyboard. Has anyone seen this happen and can offer some insight as to why it happened and how to prevent it?
spowel4 0 Newbie Poster
pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster
The backtick is something from MySQL. Is it placed around column names?
spowel4 0 Newbie Poster
I think they were around the column names; I can't be sure about that, though, until the programmer is back to work next week. I'll verify with them at that time & let you know. Thanks for the reply.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.