SQL server query problem

[Mattastic]

Hi there,

Could anyone tll me what wrong with the sql below?

It doesn't work.

INSERT INTO courses (applicationid, ccoursename) VALUES (2974,'228'),
(2974,'328'), (2974,'204'), (2974,'339');

Thankyou

[rmorgan]

The data with the single quotes, is that text or an integer? Check your
datatype for the column it is being inserted into. The quotes could be causing
the problem if you are inserting it into a integer datatype

[paross1]

You can only insert one set of falues at a time, and it looks like you are
attempting to insert 4. Loop through the insert statement, of write 4 distinct
insert statements. Are these values "hard coded" or from some other query,
etc.? If they are from a query, you can use a select statmement in place of the
VALUES statement.

INSERT INTO courses (applicationid, ccoursename) VALUES (2974,'228');
INSERT INTO courses (applicationid, ccoursename) VALUES (2974,'328');
INSERT INTO courses (applicationid, ccoursename) VALUES (2974,'204');
INSERT INTO courses (applicationid, ccoursename) VALUES (2974,'339');

Phil

[Mattastic]

Thanks for this, you can insert multiple values in mysql though can't you?

[paross1]

It looks like MySQL supports multiple value lists on inserts, at least
according to their reference manual: The INSERT ... VALUES form with multiple
value lists is supported in MySQL 3.22.5 or later.

What database are you using?

Phil