Windows 10, VB .Net, VS 2019:
I have a Visual Studio dataset with a number of tables.
The database is Microsoft SQL accessed with the msoledbsql_64.msi driver.
I click "configure" on the data table adapters and input SQL query.
So far so good, I can fill the tables. BUT when I check on the "UpdateCommand.CommandText, InsertCommand.CommandText and the DeleteCommand.CommandText which are automatically generated, each column name is enclosed in ` (tic) like ` Name1`...`Name2` and so on. I could understand [...] but not these crazy tic marks which are rejected by the SQL Server.
I have written code to edit all the queries and remove the tics. But where did they come from, what caused this strange query?