跳到主要內容

發表文章

目前顯示的是 7月, 2012的文章

[SQL] 找出相近Key值兩筆資料的SQL

SELECT a.poid from [Article] a left join [Article] b on a.poid<=b.poid  where a.poid<=$cs and b.poid<=$cs  group by a.poid having count(b.poid)<=2 之前的語法有錯 修正如下 SELECT top 2 a.poid from [Article] a left join [Article] b on a.poid<=b.poid where a.poid<=$cs and b.poid<=$cs group by a.poid order by count(b.poid) asc

[widows]Autoit windows GUI自動化程式

AutoIt v3 is a freeware BASIC-like scripting language designed for automating the Windows GUI and general scripting. It uses a combination of simulated keystrokes, mouse movement and window/control manipulation in order to automate tasks in a way not possible or reliable with other languages (e.g. VBScript and SendKeys). AutoIt is also very small, self-contained and will run on all versions of Windows out-of-the-box with no annoying “runtimes” required! autoIT