how to modify a column ?

[satellite03]

here i am in search of a SQL command. i want to modify(NOT DELETE) some column value in my MS SQL database.what would be the query ?
what is the command to modify column values ?

 

[Krickles]

Use the UPDATE command.

For a single record:

UPDATE

SET [fieldX] = new value
WHERE [fieldY] = primary key or some other field which distinguishes the row

For a mass update (e.g., pricing changes by 10% on all prices):

UPDATE products
SET price = (price * 1.1)

No where clause needed because you are updating all records.

I hope this helps.

Krickles | 1.6180