' Array
array01 = Array("A","B","C")
For i = 0 To UBound(array01)
msgbox array01(i)
Next
' Split into Array
strary = "A,B,C"
array01 = split(strary,",")
For i = 0 To UBound(array01)
msgbox array01(i)
Next
' Dymanic Array
Dim ary()
reDim ary(1)
ary(0) = "一個"
msgbox(Ubound(ary))
msgbox(ary(0))
reDim ary(2)
ary(1) = "2個"
msgbox(Ubound(ary))
msgbox(ary(1))
'msgbox(ary(0))
' ReDim保留資料
ReDim Preserve ary(5)
msgbox ary(0)
msgbox ary(1)
Brad Chen's Developer Blog Azure Database Data science Machine Learning Cloud
訂閱:
張貼留言 (Atom)
SQL Server Analysis Service
SQL Server Analysis Service
-
1.安裝了Oracle Client,就可以用Oracle Net Manager工具來設定TNS連線設定(Tnsnames.ora) Oracle Client 18.3 Installation 安裝Oracle Client 18.3 2.啟動Oracle Ne...
-
SQL Server Integration Service可以透過內建的OLE DB Source連線到Oracle匯出資料,但無法寫入資料到Oracle,Attunity公司針對這個功能提供了SSIS的連結Source,並且聽說資料傳送效率非常好,本人沒有測試過效能,有興趣的...
-
Guideline for SQL Server configuration, installation and database creation
沒有留言:
張貼留言