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?

Recommended Answers

All 2 Replies

The backtick is something from MySQL. Is it placed around column names?

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, learning, and sharing knowledge.