Update Multiple Columns

Question

I have the following situation, I need to update the table SB1300 in the fields B1_DESC and B1_CODBAR for several lines.

The Where will be the B1_XCODORI

I can do it in the same query?

Answer 1

Yes you can, your update statement would look like this

update SB1300 
set B1_DESC = 'novo valor', B1_CODBAR = 'novo valor'
where B1_XCODORI = /*sua condição*/