Unanswered: Inserting identical data in multiple rows under one column SQL.
I have a table named "inventory". I have one field which is called "itemID". There are 250 items in the database. I then add a new field which is called "itemDate". I now need to insert 10/12/2005 for each row in the datebase under the "itemDate" column. Doing this 250 times would obviously be a little time consuming.
How would one write this SQL to populate a column with the same data?