List all the columns in a table
sql - How do I list all the columns in a table? - Stack Overflow
MyHotKey
標籤：
工作
,
AutoHotKey
- Press ESC twice to close current window.
- Press middle button in Expolorer to go parent folder.
- Press hold LButton and Press RButton to open quick menu.
- Press MButton in taskbar to mute.
- Win + Wheel down, window to minimize.
- Win + Wheel up, window to maximize.
- Win + MButton, Pin on top.
- Win + NumpadAdd, Increase the transparency of the active window.
- Win + NumpadSub, Decrease the transparency of the active window.
- Win + Numpad0, Reset the transparency of the active window.
- Win + V, Pure text.
- Win + X, Exit App.
- Win + S, Folder "MySoftware".
- Win + G, Greenshot.
- Win + C, Copy file/folder path.
- Win + N, NotePad++.
- Win + T, Paste FormatTime "yyMMddHHmmss".
- Win + Q, Quick App Menu.
- Win + E, Open My Computer without folder list.
- Win + W, Resize the active window to 800x600.
- Win + LButton, Move the active window without having to click on the title bar.
網路伺服器當機造成使用者開啟檔案總管無反應
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Advanced]
"NoNetCrawling"=dword:00000001
網路伺服器當機使用者開啟本機檔案反應都會很慢 - iT邦幫忙::IT知識分享社群
Youtube Popup Player
標籤：
Bookmarklet
,
gist
Youtube Popup Player
Youtube Popup Player
Firefox如果無法彈出，請設定about:config
browser.link.open_newwindow.restriction
值：整數 (Integer)
新連結開啟於分頁或新視窗
Javascript 編程風格
標籤：
JavaScript
,
tips
- 大括號
- 表示區塊起首的大括號，不要另起一行。因為Javascript會自動添加句末的分號，導致一些難以察覺的錯誤。
- 圓括號
- 調用函數的時候，函數名與左括號之間沒有空格。
- 函數名與參數序列之間，沒有空格。
- 所有其他語法元素與左括號之間，都有一個空格。
- 不要省略句末的分號。
- 使用"嚴格相等"（===）運算符，取代"相等"（==）運算符。
- 全區變數，採用大寫表示。
- 建構式函數名，採用首字母大寫；其他函數名，一律首字母小寫。
- 總是使用大括號表示區塊。
Javascript編程風格 - 阮一峰的網絡日志
javascript 物件導向
標籤：
gist
,
JavaScript
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| //不建議使用 | |
| //new Object | |
| var person = new Object(); | |
| person.name = 'Tom'; | |
| person.age = 25; | |
| person.sayHi = function() { | |
| console.log('Hi, I am ' + this.name + '.'); | |
| }; | |
| //Factory Paradigm | |
| function createPerson(name, age) { | |
| var o = new Object(); | |
| o.name = name; | |
| o.age = age; | |
| o.sayHi = function() { | |
| console.log('Hi, I am ' + o.name + '.'); | |
| }; | |
| return o; | |
| } | |
| var person1 = createPerson('Tom', 20); | |
| var person2 = createPerson('Joe', 21); | |
| //如有共用的方法，建議加在prototype中 | |
| //Object Literal | |
| var person = { | |
| name: 'Tom', | |
| age: 25, | |
| sayHi: function() { | |
| console.log('Hi, I am ' + this.name + '.'); | |
| } | |
| }; | |
| //Constructor Paradigm | |
| function Person(name, age) { | |
| this.name = name; | |
| this.age = age; | |
| this.sayHi = function() { | |
| console.log('Hi, I am ' + this.name + '.'); | |
| }; | |
| } | |
| var person1 = new Person('Tom', 20); | |
| var person2 = new Person('Joe', 21); | |
| //Hybrid Constructor / Prototype Paradigm | |
| function Person(name, age) { | |
| this.name = name; | |
| this.age = age; | |
| } | |
| Person.prototype.sayHi = function() { | |
| console.log('Hi, I am ' + this.name + '.'); | |
| }; |
JavaScript 物件導向介紹 | MDN
Javascript Array methods
標籤：
JavaScript
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [1, 2, 3, 4].forEach(console.log); | |
| /* | |
| 1 0 [ 1, 2, 3, 4 ] | |
| 2 1 [ 1, 2, 3, 4 ] | |
| 3 2 [ 1, 2, 3, 4 ] | |
| 4 3 [ 1, 2, 3, 4 ] | |
| */ | |
| [1, 2, 3, 4].forEach(function(item, index, array) { | |
| console.log(); | |
| }); | |
| /* | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| */ |
every()--------在陳例的每個元素上運行給定函數，如果給定函數對每個項都返回true,則返回true
filter()---------在陣列的每個元素上運行給定函數，並返回包含令給定函數返回true的那些元素
forEach()------在陣列的每個元素上運行給定函數，該方法沒有返回值
map()---------在陣列的每個元素上運行給定函數並返回每次給定函數的返回值組成的陣列
some()--------在陣列的每個元素上運行給定函數，如果給定函數在任意一個元素上返回true,則返回true
Javascript新特性：數組的擴展 - iRavior - 博客園
Array every method - JavaScript | MDN
Array some method - JavaScript | MDN
Array filter method - JavaScript | MDN
Array map method - JavaScript | MDN
Array.forEach - JavaScript | MDN
解除禁止選取
標籤：
Bookmarklet
javascript: (function () {
function R(a) {
ona = "on" + a;
if (window.addEventListener) window.addEventListener(a, function (e) {
for (var n = e.originalTarget; n; n = n.parentNode) n[ona] = null;
}, true);
window[ona] = null;
document[ona] = null;
if (document.body) document.body[ona] = null;
}
function userSelect() {
var css = document.createElement("style");
css.type = "text/css";
document.getElementsByTagName("head")[0].appendChild(css);
css.innerHTML = "*{-moz-user-select:text!important}";
}
R("contextmenu");
R("click");
R("mousedown");
R("mouseup");
R("selectstart");
userSelect();
})()
訂閱：
文章
(
Atom
)