By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
462,868 Members | 675 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 462,868 IT Pros & Developers. It's quick & easy.

SQL compact edition 3.5 insert multiple rows

P: 6

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) ,
('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?

Mar 6 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 2,878
You have to issue an INSERT for each of those values.

-- CK
Mar 6 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.