|
-
Jun 15th, 2006, 06:08 AM
#1
Thread Starter
Frenzied Member
[RESOLVED] INSERT INTO all records in a table
Hi all,
I want insert a number and a date into all the records in a particular table. I.E. There could be 100 records in a table and I want to insert the same week# and date into all the records. However, when I try to use the INSERT INTO function of SQL it is simply adding 1 new record to the table and adding the week# and date to this record.
How do I add the week' and date to all records in the table?
Thanks,
Last edited by Hack; Jun 15th, 2006 at 08:19 AM.
Reason: Added [RESOLVED] to thread title and green "resolved" checkmark
Mel
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|