Dean's Blog

2017年9月13日星期三

Select Into v.s. Insert into From

1. Select Into

Create a new table in the destination database
select * into sif.dbo.callDetail from I3_IC.dbo.calldetail_viw;

2. Insert into From

Insert into existing table, column needs to assigned explicitly. * may not work in some databases.

INSERT INTO table2 (column1, column2, column3, ...)
SELECT column1, column2, column3, ...
FROM table1
WHERE condition;

2017年9月7日星期四

Pentaho Data Integration (Kettle)

http://ithelp.ithome.com.tw/articles/10186567

2017年9月4日星期一

Logback

https://examples.javacodegeeks.com/enterprise-java/logback/logback-file-appender-example-2/

https://stackoverflow.com/questions/2488558/logback-to-log-different-messages-to-two-files