Subject | Update |
---|---|
Author | Robert F. Tulloch |
Post date | 2000-10-11T18:28:12Z |
HI:
UPDATE MYTABLE
SET R1 = 1.50
WHERE R1 IS NULL;
UPDATE MYTABLE
SET R2 = 1.50
WHERE R2 IS NULL;
UPDATE MYTABLE
SET R3 = 1.50
WHERE R3 IS NULL
etc, etc.
Anyway there can be combined with 1 update?
Thanks.
Best
regards
UPDATE MYTABLE
SET R1 = 1.50
WHERE R1 IS NULL;
UPDATE MYTABLE
SET R2 = 1.50
WHERE R2 IS NULL;
UPDATE MYTABLE
SET R3 = 1.50
WHERE R3 IS NULL
etc, etc.
Anyway there can be combined with 1 update?
Thanks.
Best
regards