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.
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.