Hi.

How can I update a complete column in a table ?
I have a table with 2 columns: col_A and col_B and I want to add '1' to every cell of col_A.
Something like:
update tblName set col_A = ((select col_A from tblName)+1) ??

The +1 is less important the operation on all the cell is the issue.

10x.

: Hi.
:
: How can I update a complete column in a table ?
: I have a table with 2 columns: col_A and col_B and I want to add '1' to every cell of col_A.
: Something like:
: update tblName set col_A = ((select col_A from tblName)+1) ??
:
: The +1 is less important the operation on all the cell is the issue.
:
: 10x.
:

Update tblName set col_A = col_A + 1