insertCommand.CommandText = "INSERT INTO Owner VALUES ('" & tbxFirstName.Text & "', '" & tbxLastName.Text & "')"

            insertCommand.CommandText &= "INSERT INTO CD VALUES ('" & tbxArtist.Text & "', '" & tbxAlbum.Text & "')"

            insertCommand.CommandText &= "INSERT INTO CDTracks VALUES ('" & tbxTrackName.Text & "')"

]
insertCommand.CommandText = "INSERT INTO Owner (Col1Name,Col2Name) VALUES ('" & tbxFirstName.Text & "', '" & tbxLastName.Text & "')"

            insertCommand.CommandText &= "INSERT INTO CD (Col1Name,Col2Name) VALUES ('" & tbxArtist.Text & "', '" & tbxAlbum.Text & "')"

            insertCommand.CommandText &= "INSERT INTO CDTracks (ColName) VALUES ('" & tbxTrackName.Text & "')"

quote:

---

Then when I check my DB I find that the first table has been updated

---

CREATE TABLE #tmp1(id1 INT, id2 INT);

-- I can do this - because I am supplying id1 and id2.
INSERT INTO #tmp1 VALUES (1,1);

-- But I cannot do this - because I am supplying only one value.
INSERT INTO #tmp1 VALUES (2);

-- Instead, I would do this IF I want id2 to be null in this insert.
INSERT INTO #tmp1 (id1) VALUES (2);

-- 
DROP TABLE #tmp1;