UPDATE Statement

[msnraju]

To update records in a Table.

example:
UPDATE [Sales Line] SET Quantity = 0 WHERE [Document Type] = 'Order' AND [Document No.]='ORD-001'