애플자라

SELECT count(*) FROM EMAIL_GRP A LEFT OUTER JOIN EMAIL_TARGET B ON A.MAIL_GRP_NO = B.MAIL_GRP_NO WHERE B.SEND_YN = 'N' AND A.SEND_TYPE_CD='S' UPDATE EMAIL_TARGET B SET B.SEND_YN = 'Y' WHERE EXISTS (SELECT MAIL_GRP_NO FROM EMAIL_GRP A WHERE A.MAIL_GRP_NO = B.MAIL_GRP_NO AND A.SEND_TYPE_CD = 'S' AND B.SEND_YN = 'N')

update (select * from pmegatest1 where c1=2 and c2='pmega' fetch first 1 rows only) set c1=11 with UR delete from (select * from pmegatest1 where c1=2 and c2='pmega' fetch first 1 rows only) with UR [출처] IBM DB2에서 select and update,delete 하기 (큰틀) |작성자 가이사 DELETE FROM (SELECT * FROM ${LIST_TABLE} WHERE POST_ID = '${POST_ID}' FETCH FIRST ${COMMIT_CNT} ROWS ONLY) WITH UR

호환기능팩 http://www.microsoft.com/downloads/details.aspx?FamilyID=941b3470-3ae9-4aee-8f43-c6bb74cd1466&DisplayLang=ko Office 2003 서비스 팩 3(SP3) http://www.microsoft.com/downloads/details.aspx?familyid=E25B7049-3E13-433B-B9D2-5E3C1132F206&displaylang=ko

새 창으로 열기 "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" "%1" -- Office2003 "C:\Program Files\Microsoft Office\Office14\EXCEL.EXE" "%1" -- Office2010 기본값 설정 http://drparksc.blog.me/20101891822 : Windows7새창

-- DB MSSQL attach sp_attach_db @dbname = 'AMAILCS', @filename1 = 'D:\MSSQL\Data\AmailCS\AMAILCS_Data.MDF', @filename2 = 'D:\MSSQL\Log\AmailCS\AMAILCS_Log.LDF' sp_attach_db @dbname = 'AMAILCS_DEV', @filename1 = 'D:\MSSQL\Data\AmailCS_Dev\AMAILCS_DEV_Data.MDF', @filename2 = 'D:\MSSQL\Log\AmailCS_Dev\AMAILCS_DEV_Log.LDF' sp_attach_db @dbname = 'AMAILCSNEW', @filename1 = 'D:\MSSQL\Data\AmailCS_New\..

-- 일단위 Select DATEPART(dd, order_dt), count(order_no) From 주문테이블 group by DATEPART(dd, order_dt) order by DATEPART(dd, order_dt) -- 주 단위 Select DATEPART(ww, order_dt), count(order_no) From 주문테이블 group by DATEPART(ww, order_dt) order by DATEPART(ww, order_dt) -- 월단위 Select DATEPART(mm, order_dt), count(order_no) From 주문테이블 group by DATEPART(mm, order_dt) order by DATEPART(mm, order_dt) -- 년단위 Sel..

echo $LANG export LANG=c

USE master GO --EXEC sp_addumpdevice 'disk', 'AMAILCS_MSSQL_Backup', 'D:\CS_Amail_Backup\AMAILCS_MSSQL_Backup.bak' --EXEC sp_addumpdevice 'disk', 'AMAILCS_DEV_MSSQL_Backup', 'D:\CS_Amail_Backup\AMAILCS_DEV_MSSQL_Backup.bak' --EXEC sp_addumpdevice 'disk', 'AMAILCSNEW_MSSQL_Backup', 'D:\CS_Amail_Backup\AMAILCSNEW_MSSQL_Backup.bak' --EXEC sp_addumpdevice 'disk', 'CS_MSSQL_Backup', 'D:\CS_Amail_Back..

[Tomcat Base]Catalina.sh JAVA_OPTS="$JAVA_OPTS -Xms256m -Xmx512m" 톰캣재구동하였음

CREATE OR REPLACE TRIGGER EMS_MAILQUEUE_DELETE_TRIGGER BEFORE DELETE ON EMS_MAILQUEUE FOR EACH ROW BEGIN INSERT INTO EMS_MAILQUEUE_BACK ( MASTER_SEQ, CIS_TF_KEY, MAIL_CODE, TO_ID, TO_NAME, TO_EMAIL, FROM_NAME, FROM_EMAIL, REPLY_EMAIL, SUBJECT, REQ_DATE, TARGET_FLAG, TARGET_DATE, REG_DATE, MAP1, MAP2, MAP3, MAP4, MAP5, MAP6, MAP7, MAP8, MAP9, MAP10, SECURE_PWD, FILE_SEQ, CIS_SEND_FLAG, CIS_FLAG) ..