0
Answer

multiple insert statement

Ask a question
ian 0

ian 0

19y
1.7k
1
Hey Gang, Got a problem trying to use an insert .. select statement to populate one table with anothers auto_generated key. I don't know if i have the tables in sql server done properly as the tables are as follows: [b]tbl_disclaimers[/b] recnumberid int(4) not null -> identity yes, foreign key callnumber varchar(255) not null, backup bit(1) null, antivirus bit(1) null, delivery bit(1) null ) [b]tbl_params[/b] recnumberid int(4) not null primary key -> identity yes amount money(8) null my basic sql command is INSERT INTO tbl_params SELECT recnumberid FROM tbl_disclaimers where recnumberid = '2'