SELECT TOP 20  * FROM dbo.Dict_Pack
SELECT TOP 20 * FROM PEIS. dbo.ExamPack


TRUNCATE TABLE Dict_Pack
SET IDENTITY_INSERT [dbo].[Dict_Pack] OFF

INSERT INTO Dict_Pack
(ID, Name, SpellCode,   Sex, Marriage, Seq) 
SELECT
Id,
	NAME ,
	PYM AS SpellCode,
	SuitableGender AS Sex,
	SuitableMarriage AS Marriage, 
	SortNo AS Seq 
FROM
	PEIS.dbo.ExamPack WHERE StopOperDate IS NULL