CTE(Common Table Expressions) 遞迴查詢

多個SQL變數使用於in查詢

表格 十字Hightlight

JS Bin on jsbin.com

Combine Table Cell (合併表格欄位)

JS Bin on jsbin.com

GridView Container.DataItemIndex 用法

c# - ASP.NET GridView RowIndex As CommandArgument - Stack Overflow

iframe元表，綁定事件

使用資料表更新資料表

---

sql server - SQL update from one Table to another based on a ID match - Stack Overflow

Simple Full Screen Overlay

JS Bin

---

jquery: how can i create a simple overlay? - Stack Overflow

DataTable 轉 Excel

EnterpriseLibrary 常用語法

Imports System.Data.Common
Imports Microsoft.Practices.EnterpriseLibrary.Data

IIS Express 相關設定

appcmd.exe 路徑

"C:\Program Files\IIS Express\appcmd.exe"

啟動WebSite

"C:\Program Files\IIS Express\iisexpress.exe" /site:DemoSite

列表WebSite

appcmd.exe list site

刪除WebSite

appcmd.exe delete site "WebSite"

設定WebSite對外IP

1. 開啟 %homepath%\Documents\IISExpress\config\applicationhost.config
2. 修改<binding protocol="http" bindingInformation="*:8080:192.168.1.10" />

Query Jobs (Running, Fail, Duration)

String.prototype.smartShort()

UNION ALL vs UNION

• UNION ALL 和 UNION 不同 之處在於 UNION ALL 會將每一筆符合條件的資料都列出來，無論資料值 有無重複。 
• SQL1 union SQL2 : SQL1+SQL2 後的資料會自動重新排序, 且 SQL1 與 SQL2 的重複資料只顯示一筆。
• SQL1 union all SQL2: SQL1+SQL2 後資料不會自動重新排序, 且 SQL2 資料直接銜接到 SQL1 資料之後, 也就是 SQL1 與 SQL2 可以有重複資料。

SQL UNION ALL - 1Keydata SQL語法教學 昭佑.天翔: Oracle PL/SQL 的 union 與 union all 這兩種聯集的比較

MD5 HASH

MD5 HASH

---

MD5 and SHA1 File Checksum Calculcator - B# .NET Blog

Disable Close Button (停用關閉鈕)

Disable Close Button

---

Disable closing a window from it's close button - Support - AutoHotkey Community

Determine identity column (判斷識別規格欄位)

IF ((SELECT OBJECTPROPERTY( OBJECT_ID(N'table_name_here'), 'TableHasIdentity')) = 1)
    PRINT 'Yes'
ELSE
    PRINT 'No'

---

sql server - How do you determine what SQL Tables have an identity column programatically - Stack Overflow

HashBytes (MD5、SHA1)

Right(UPPER(sys.fn_VarBinToHexStr(HashBytes('md5', '123password456'))),32);

---

好用的 MS SQL 2005 欄位字串加密應用 ( MD5 與 SHA1 ) - IT X 4- 點部落

Command Prompt Here (在此處開啟命令視窗)

REG ADD "HKLM\Software\Classes\Folder\Shell\Cmd Here\command" /f /t REG_SZ /ve /d "cmd.exe /k cd %1" REG ADD "HKLM\Software\Classes\Folder\Shell\Cmd Here\command" /f /t REG_SZ /ve /d "cmd.exe /k pushd %1" Note:以batch執行時，請將%1更改為%%1

---

Add Command Prompt Here Shortcut to Windows Explorer
Add Command prompt here to right-click menu in Windows XP

Driver Signing (驅動程式簽署)

Local $HLMPolicy = RegRead("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Driver Signing","Policy")
Local $HLMNPolicy = RegRead("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Non-Driver Signing","Policy")
Local $HCUPolicy = RegRead("HKEY_CURRENT_USER\SOFTWARE\Microsoft\Driver Signing","Policy")
Local $HCUBOFV = RegRead("HKEY_CURRENT_USER\Software\Policies\Microsoft\Windows NT\Driver Signing","BehaviorOnFailedVerify")
Local $c=MsgBox(3,"Driver Signing","(HLM) Driver Signing: " & $HLMPolicy & @LF & "(HLM) Non-Driver Signing: " & $HLMNPolicy & @LF & "(HCU) Driver Signing: " & $HCUPolicy & @LF & "BehaviorOnFailedVerify: "& $HCUBOFV)
If $c = 6 Then
    RegWrite("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Driver Signing","Policy","REG_BINARY",Binary('0x' & '00'))
    RegWrite("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Non-Driver Signing","Policy","REG_BINARY",Binary('0x' & '00'))
    RegWrite("HKEY_CURRENT_USER\SOFTWARE\Microsoft\Driver Signing","Policy","REG_DWORD","00000000")
    RegWrite("HKEY_CURRENT_USER\Software\Policies\Microsoft\Windows NT\Driver Signing","BehaviorOnFailedVerify","REG_DWORD","00000000")
ElseIf $c = 7 Then
    RegDelete("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Driver Signing","Policy")
    RegDelete("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Non-Driver Signing","Policy")
    RegDelete("HKEY_CURRENT_USER\SOFTWARE\Microsoft\Driver Signing","Policy")
    RegDelete("HKEY_CURRENT_USER\Software\Policies\Microsoft\Windows NT\Driver Signing","BehaviorOnFailedVerify")
EndIf
EXIT

---

Driver signing registry values cannot be modified directly in Windows

---

程式只能讀取作狀態判斷
雖然可以寫值進去，但還是無效
需從“我的電腦 →內容 → 硬體 → 驅動程式簽署 → 略過”進行手動更改才有效

---

自動模擬版(XP)
$title = "系統內容"
Run("control.exe sysdm.cpl")
WinWaitActive($title)
ControlCommand($title, "", "SysTabControl321", "TabRight", "")
ControlCommand($title, "", "SysTabControl321", "TabRight", "")
ControlClick($title, "驅動程式簽署(&S)", "Button4")
ControlClick("驅動程式碼簽署選項", "略過 - 直接安裝軟體，不需要我的同意(&I)","Button1")
ControlClick("驅動程式碼簽署選項", "確定","Button5")
ControlClick($title, "確定", "Button8")