03-01-2008, 08:08
|
|
|
חבר מתאריך: 26.04.04
הודעות: 2,295
|
|
קוד:
IF EXISTS ( SELECT * FROM mytab WHERE num = 123 AND code = 'xyz')
UPDATE mytab
SET value = 'The Value'
WHERE num = 123 AND code = 'XYZ'
ELSE
INSERT INTO mytab (num, code, value)
VALUES (123, 'xyz', 'The Value')
|