--產生PACKAGE_INFO
SELECT 'INSERT INTO BAS.PACKAGE_INFO VALUES(''' + DOMAIN_NO + ''','''+PACK_NO + ''','''+PACK_NAME_CH + ''','''+PACK_NAME_TH + ''','''+PACK_NAME_EN + ''',' + CONVERT(VARCHAR,PACK_SEQ) + ')'FROM BAS.PACKAGE_INFO WHERE DOMAIN_NO= 'SFIS' ORDER BY PACK_SEQ
--產生PROGRAM_INFO
SELECT 'INSERT INTO BAS.PROGRAM_INFO VALUES(''' + PACK_NO + ''','''+PRO_NO + ''','''+PRO_PATH + ''','''+PRO_NAME_CH + ''','''+PRO_NAME_TH + ''','''+PRO_NAME_EN + ''','''+PRO_TYPE + ''',' + CONVERT(VARCHAR,VER_MAJOR)+ ',' + CONVERT(VARCHAR,VER_MINOR)+ ',' + CONVERT(VARCHAR,VER_REVISOR)+ ',' + CONVERT(VARCHAR,PRO_SEQ) + ');'FROM BAS.PROGRAM_INFO WHERE PACK_NO LIKE 'SFIS%' ORDER BY PRO_SEQ,PRO_NO
