复制SQL表数据

TRUNCATE TABLE

SET IDENTITY_INSERT dbo.tbProductCN ON 

INSERT INTO dbo.tbProductCN

        ( Code ,

        )

SELECT    id,

Code ,

         FROM HFORDERSERVER.dbo.tbproductcn    

  SET IDENTITY_INSERT dbo.tbProductCN Off