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?

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 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.