SQL Server Problem

[mattastic]

Hi There,

Could anyone tell me why this doesn't work in sql server?

INSERT INTO courses (applicationid, ccoursename) VALUES (2973,'328'), (2973,'330'), (2973,'332'), (2973,'227');

Thankyou

[Cstick]

There may be a better way, but try this instead:

INSERT INTO courses (applicationid, ccoursename) SELECT 2973,'328';
INSERT INTO courses (applicationid, ccoursename) SELECT 2973,'330';
INSERT INTO courses (applicationid, ccoursename) SELECT 2973,'332';
INSERT INTO courses (applicationid, ccoursename) SELECT 2973,'227';

[chazzy]

Hi There,

Could anyone tell me why this doesn't work in sql server?

INSERT INTO courses (applicationid, ccoursename) VALUES (2973,'328'), (2973,'330'), (2973,'332'), (2973,'227');

Thankyou

Looks fine. Are you getting an error back?