SQL alter column datatype from nvarchar to int

MS-SQL ,

 

1. Create a new column that's an integer:

ALTER TABLE tableName ADD newCol int;

2. Select the data from the old column into the new one:

UPDATE tableName SET newCol = CAST(oldCol AS int);

3. Drop the old column.