SET IDENTITY_INSERT dbo.AutomaticStationList ON --identity insert edilmesine izin verir GO INSERT INTO dbo.AutomaticStationList (Id, Name, Address, City, District, Phone,Fax) SELECT id,name,Address,city,district,Kod+''+ Phone,Fax FROM dbo.AutomaticStationListDT WHERE id is not null go SET IDENTITY_INSERT dbo.AutomaticStationList OFF ---------------------------------------------------------------- INSERT INTO dbo.AutomaticStationList (Name, Address, City, District, Phone,Fax) SELECT name,Address,city,district,cast(Kod as nvarchar(4))+' '+ cast(Phone as nvarchar(55)),Fax --numeric alan KOD ve ntext olan alan Phone cast ile varchar dönüştürüldü. FROM dbo.AutomaticStationListDT WHERE id is not null
