Update Multiple Columns

0

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

The where will be B1_XCODORI

Can I do the same query?

    
asked by anonymous 06.12.2017 / 14:47

1 answer

0

If 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*/
    
06.12.2017 / 14:51