2017年9月26日 星期二
RRD Tool
http://www.study-area.org/tips/rrdtool/rrdtool.html
http://ycfu.blog.mypc.tw/2008/05/rrdtool.html
http://blog.csdn.net/jndxjing/article/details/8014410
2017年9月14日 星期四
SQL Server Data Format
1. Get Date in a format such as: 2017/09/11
CONVERT(char(10),DATEADD(day,-(1),GETDATE()) ,111) AS Date
CONVERT(char(10),DATEADD(day,-(1),GETDATE()) ,111) AS Date
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;
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日 星期四
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
https://stackoverflow.com/questions/2488558/logback-to-log-different-messages-to-two-files
2017年8月25日 星期五
UI/UX process
https://blog.akanelee.me/posts/278602-ux-is-not-a-wireframe/
https://blog.akanelee.me/posts/686437-ui-design-process/
https://blog.akanelee.me/posts/686437-ui-design-process/
2017年8月14日 星期一
IOT
https://villesmartblog.wordpress.com/2016/11/29/iot-%E5%B8%B8%E7%94%A8%E7%9A%84%E5%82%B3%E8%BC%B8%E5%8D%94%E5%AE%9A%E4%BB%8B%E7%B4%B9/
訂閱:
文章 (Atom)