sql - how can you convert an ASCII value from another database into an integer column? -

how can convert ascii value database integer column sql server? i'm importing data using data wizard , trying convert need update each column in table unique number.... don't know how this

you have run stored procedure when new data added database. but, convert int when inserting, should help:

insert newtable newcolumn select (cast oldcolumn int) oldtable;