update table set column = a.i code example

Example: sql change column in existing table

'This adds 'NOT NULL' to excisting column counting in the table mytable'
ALTER TABLE mytable ALTER COLUMN counting INT NOT NULL;