I'm using SQL Management Studio 2008 to import a mysql dump. The dump was created with phpmyadmin with mssql compatibility turned on.This is what the dump looks like:
INSERT INTO frequencies (tx, rx, `mode`, description, `type`, location, `user`, modified, added) VALUES(163.11250, '', 'Nfm', test trunked radio system control. Watertower Cobh', 'Garda', 'Cork', 'Mike', '2005-02-03 23:00:00', '2005-03-15 10:38:30');
When I execute that sql I get an error
Msg 102, Level 15, State 1, Line 21
Incorrect syntax near '`'.
It looks like the syntax is wrong.Can anyone point me in the right direction. Thanks.
View Complete Post