PDA

Click to See Complete Forum and Search --> : SQL Server Problem

mattastic
02-06-2006, 07:52 AM
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
02-06-2006, 08:00 AM
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
02-06-2006, 07:09 PM
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?