by Vic Sergean » Wed, 29 Jan 2003 19:54:35
Cane anybody inform me, if there is a way to replace a
field of all records in a recordset to the same value
(reset to 0 for example). For preference in one
instruction, instead of looping the full recordset and
change each record with a update command record by
record, because there are a lot of records.
Many thanks
Best Regards,
Vic
by Val Mazu » Wed, 29 Jan 2003 22:03:19
It is simple UPDATE SQL statement
UPDATE MyTable SET FieldName=0
it will set FieldName to 0 in all records of MyTable
--
Val Mazur
Microsoft MVP
Quote:> Hi,
> Cane anybody inform me, if there is a way to replace a
> field of all records in a recordset to the same value
> (reset to 0 for example). For preference in one
> instruction, instead of looping the full recordset and
> change each record with a update command record by
> record, because there are a lot of records.
> Many thanks
> Best Regards,
> Vic
1. insert data from one field in one table to another field in another table
I have 8500 records in a table called items which has a
field called itemlookupcode.
I have another table called alias which has a field called
alias.
I need to replace the itemlookupcode data with the alias
data.
There is a join between the 2 tables on ID
Does anybody know how this is done Please
2. Updategram with mapping schema problem (OLEDB)
3. Need Help: search/replace data in one field/one record, by queries or script: PDOX5
4. Oracle Developer/DBA opportunity in Raleigh, NC or Austin, TX
5. Replacing one field with another field
6. Help w/CSTACKZ environment variable
7. getting distinct values from one table ordered by value from another table
8. Replace one column values with another
9. Fill field in one table from field in another table
10. merging two fields into one field with value lists
11. #Deleted replaces field values
12. Replacing null fields with empty values thru ASP