SELECT TOP 20 * FROM dbo.Dict_Conclusion SELECT TOP 20 * FROM PEIS.DBO.Conclusion TRUNCATE TABLE Dict_Conclusion SET IDENTITY_INSERT dbo.Dict_Conclusion ON INSERT INTO Dict_Conclusion (ID, ConclusionName, SpellCode, Description, Instructions, Suggestion, Advice, DietaryGuidance, Sex ) SELECT Id, NAME AS ConclusionName, PYM AS SpellCode, Description, Instructions, Suggestion , Advice, DietaryGuidance, DiseasesGender AS SEX FROM PEIS.DBO.Conclusion WHERE StopOperDate IS NULL SET IDENTITY_INSERT dbo.Dict_Conclusion OFF