自動產生菜單SQL

--產生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