Hi

Look at UPDATE statement synthax. You can add as many fields as you want.

Update MyTable Set MyField1 = @NewValue, MyField2 = @NewValue2, ... MyFieldN = @NewValueN
Where conditions

Hope this helps.


>sir, I have one more qustions, if this table contains three fileds then how can i update
>iduvidualy in a single statement.
>
>UPDATE mytable
> SET myfield = @NewValue
> WHERE < whetever conditions >
> AND myfield <> @NewValue
>>
>>While updating data in the server, i want to skip the field if and only if the new value
>>and old the values are same. Othewise i want to update the field with new value.
>>how will i write Sql Statement for this.
>>
>
>Regards
>Abdulla