Variant function: VarIsEmpty VS VarIsNULL

unassined :

if Not VarIsEmpty( DeltaDs.Fields[i].NewValue ) then ...

NULL :

if Not VarIsNULL( DeltaDs.Fields[i].NewValue ) then ...

資料來源：http://www.sql.ru/forum/actualthread.aspx?tid=329100

使用 OLE 開啟 Excel 的小陷井

從MSDN上看到Workbook.Open函式是這樣寫的：

Workbook Open(
 [In] string Filename, 
 [In, Optional] object UpdateLinks, 
 [In, Optional] object ReadOnly, 
 [In, Optional] object Format, 
 [In, Optional] object Password, 
 [In, Optional] object WriteResPassword, 
 [In, Optional] object IgnoreReadOnlyRecommended, 
 [In, Optional] object Origin, 
 [In, Optional] object Delimiter, 
 [In, Optional] object Editable, 
 [In, Optional] object Notify, 
 [In, Optional] object Converter, 
 [In, Optional] object AddToMru, 
 [In, Optional] object Local, 
 [In, Optional] object CorruptLoad
);

一票網站在抄來抄去，除了第一個參數是Filename不變外，其它不是都沒給值，就是直接給EmptyParam

ADO的SQLMonitor實作 -- ADOMonitor

Build your own profiler using ADO

相當有意思的文章內容，下次再來試試