Hello, I would do as follows there are many others but please verify whether the expected results.
Create TAble #Old_Table
(Id int, National_Code varchar(20))
Create TAble #New_Table
(Id int, National_Code varchar(20))
Insert into #Old_Table
Values (1,'0000000000')
,(2,...