INSERT INTO dbo.T_TS_GOODSCATEGORY SELECT * FROM [180320]..T_TS_GOODSCATEGORY

INSERT INTO dbo.T_TS_GOODSDETAIL SELECT * FROM [180320]..T_TS_GOODSDETAIL

INSERT INTO dbo.T_TS_CARDCATEGORY SELECT * FROM [180320]..T_TS_CARDCATEGORY WHERE F_ID NOT IN (SELECT F_ID FROM T_TS_CARDCATEGORY)


INSERT INTO dbo.T_TS_CARDDETAIL  SELECT * FROM [180320]..T_TS_CARDDETAIL WHERE F_ID NOT IN (SELECT F_ID FROM T_TS_CARDDETAIL)

INSERT INTO dbo.T_TS_CUSTOMCODE SELECT * FROM [180320]..T_TS_CUSTOMCODE WHERE F_ID NOT IN (SELECT F_ID FROM T_TS_CUSTOMCODE)