Hello,
how can I insert into the sql compact edition 3.5 multiple rows.
I have following query
INSERT INTO network (name, adname, timezone) VALUES
('rm', 'rm', 1),
('pm', pm', 1) ,
('PLURIELLES', 'PLURIELLES', 1),
('SPORTS', 'SPORTS', 1);
if I do this in the editor of the microsoft visual studio 2008 I get following error
'Unable to parse query text.'
Is this not possible to do in the compact edition? Or have I an error in my query?
thanks