https://social.msdn.microsoft.com/Forums/zh-TW/3a960e44-4afc-40a1-b17e-a7465a1c04be/postgresql-connection-?forum=236
http://www.blueshop.com.tw/board/FUM20041006161839LRJ/BRD20121210214021YIC.html
http://www.blueshop.com.tw/board/FUM20041006152735ZFS/BRD20100429153313E4D.html
http://www.blueshop.com.tw/board/FUM20041006152735ZFS/BRD20080618201818PVA.html
2017年4月13日 星期四
2016年7月4日 星期一
2016年6月30日 星期四
comment command for confluence
select a.creationdate,a.lastmoddate,b.username from content a ,user_mapping b where a.contenttype='COMMENT' and a.creator=b.user_key and a.creationdate between '2015/9/30' and '2015/10/1'
select count(*),b.username from content a ,user_mapping b where a.contenttype='COMMENT' and a.creator=b.user_key and a.creationdate between '2015/9/30' and '2015/10/1' group by b.username
2016年6月18日 星期六
confluence-comment by author
select a.creationdate,b.username from content a,user_mapping b where a.contenttype='COMMENT' and a.creator=b.user_key and a.creationdate between '2016/4/1' and '2016/4/20' order by creationdate desc
2016年4月28日 星期四
2016年4月26日 星期二
information
http://www.programmableweb.com/news/63-translation-apis-bing-google-translate-and-google-ajax-language/2013/01/15
https://ctrlq.org/code/19909-google-translate-api
http://www.oxforddictionaries.com/us/
http://www.macmillandictionaries.com/dictionary-online/
http://www.programmableweb.com/category/dictionary/api
https://ctrlq.org/code/19909-google-translate-api
http://www.oxforddictionaries.com/us/
http://www.macmillandictionaries.com/dictionary-online/
http://www.programmableweb.com/category/dictionary/api
2016年2月18日 星期四
sql全文檢索的使用說明
--移除全文檢索
USE ServerLog;
GO
EXEC sp_fulltext_table 'tmp', 'drop';
GO
USE ServerLog;
GO
EXEC sp_fulltext_table 'tmp', 'drop';
GO
--建立全文檢索資訊
USE ServerLog;
GO
EXEC sp_fulltext_table 'tmp', 'create', 'tmp', 'PK_100and10';
USE ServerLog;
GO
EXEC sp_fulltext_table 'tmp', 'create', 'tmp', 'PK_100and10';
--Add some columns
EXEC sp_fulltext_column 'tmp','MsgText','add';
-- Activate the full-text index
EXEC sp_fulltext_table 'tmp','activate';
GO
--重建索引資料匣
USE ServerLog;
GO
EXEC sp_fulltext_catalog 'full28', 'rebuild';
GO
EXEC sp_fulltext_column 'tmp','MsgText','add';
-- Activate the full-text index
EXEC sp_fulltext_table 'tmp','activate';
GO
--重建索引資料匣
USE ServerLog;
GO
EXEC sp_fulltext_catalog 'full28', 'rebuild';
GO
--索引狀態確認
USE ServerLog;
GO
EXEC sp_fulltext_table 'tmp', 'Start_change_tracking';
EXEC sp_fulltext_table 'tmp', 'Start_background_updateindex';
GO
USE ServerLog;
GO
EXEC sp_fulltext_table 'tmp', 'Start_change_tracking';
EXEC sp_fulltext_table 'tmp', 'Start_background_updateindex';
GO
訂閱:
文章 (Atom)
