` (backticks) around field names in sql generated error when executing sql in SQL Server.

stefangabos / world_countries

Constantly updated lists of world countries and their associated alpha-2, alpha-3 and numeric country codes as defined by the ISO 3166 standard, available in CSV, JSON , PHP, SQL and XML formats, in multiple languages and with national flags included; also available are the ISO 3166-2 codes of provinces/ states associated with the countries

http://stefangabos.github.io/world_countries/

Other

1.35k stars 375 forks source link

` (backticks) around field names in sql generated error when executing sql in SQL Server. #18

Closed kiranshahi closed 5 years ago

kiranshahi commented 5 years ago

screenshot 23

` is not ANSI-SQL compliant so I think its better to use " (double quote) in place of it.

kiranshahi commented 5 years ago

Also it think better to use two single quote ('') in place of \'