°õ¦æ¶¥¬q¿ù»~13 «¬ºA¤£²Å¦X
- ©«¤l
- 172
- ¥DÃD
- 39
- ºëµØ
- 20
- ¿n¤À
- 177
- ÂI¦W
- 0
- §@·~¨t²Î
- Microsoft Windows XP
- ³nÅ骩¥»
- Microsoft Office 2003
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- °ª¶¯
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2023-3-19
|
±zªºsql¦r¦ê¥Î¿ù¤F! ¤Ö¤F&
¿ù»~
ssql = ssql "select a.*,b.*,c.*,d.* from dbo.Stock a" & Chr(13)
¥¿½T
ssql = ssql & "select a.*,b.*,c.*,d.* from dbo.Stock a" & Chr(13)
¥þ³¡³£¦³¤Ö³á~ |
|
Y¬O§Ú¦^µª¡A¨Ï±zº¡·N¡A½Ð±zÅý§Úª¾¹D¡I
Y¬O§Úªº¦^ÂСA±z¤´¦³¨ä¥L¨£¸Ñ¡A¤]½Ð±z¤£¶Þ«ü±Ð¡I
|
|
|
|
|
- ©«¤l
- 172
- ¥DÃD
- 39
- ºëµØ
- 20
- ¿n¤À
- 177
- ÂI¦W
- 0
- §@·~¨t²Î
- Microsoft Windows XP
- ³nÅ骩¥»
- Microsoft Office 2003
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- °ª¶¯
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2023-3-19
|
¤p§Ì¶K»yªk®É¡A¨ä¹ê¬O¦³&¡A¦ý¬O³Ì«á¨Ã¨S¦³¥X²{¡A½Ðmin¤j¤jÀ°§Ú¬Ý¤@¤U¡A¶]¥X¨ÓªºÏ¿ªG¦p¤U¹Ï
joey0415 µoªí©ó 2010/6/28 05:49 PM
³Ò¾r±NÀÉ®×PO¤W¨Ó~ |
|
Y¬O§Ú¦^µª¡A¨Ï±zº¡·N¡A½Ð±zÅý§Úª¾¹D¡I
Y¬O§Úªº¦^ÂСA±z¤´¦³¨ä¥L¨£¸Ñ¡A¤]½Ð±z¤£¶Þ«ü±Ð¡I
|
|
|
|
|
- ©«¤l
- 172
- ¥DÃD
- 39
- ºëµØ
- 20
- ¿n¤À
- 177
- ÂI¦W
- 0
- §@·~¨t²Î
- Microsoft Windows XP
- ³nÅ骩¥»
- Microsoft Office 2003
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- °ª¶¯
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2023-3-19
|
ssql = ""
ssql = ssql & vbCrLf & "select a.*,b.*,c.*,d.*"
ssql = ssql & vbCrLf & "from dbo.Stock a"
ssql = ssql & vbCrLf & "left join dbo.CreditExchange b on a.sdate=b.sdate and a.stockid=b.stockid"
ssql = ssql & vbCrLf & "left join dbo.NLDL c on a.sdate=c.sdate and a.stockid=c.stockid"
ssql = ssql & vbCrLf & "left join dbo.CompTrade d on a.sdate=d.sdate and a.stockid=d.stockid"
ssql = ssql & vbCrLf & "where a.stockid>1000 and a.sdate>='2010-06-09' "
ssql = ssql & vbCrLf & "order by a.stockid,a.sdate"
§ï¥Î³o¼Ëªº¤è¦¡ ¬Ý°_¨Ó¤ñ¸û¾ã»ô³á...
èè¤p§Ì¬Ý¤F¦Ñ¥b¤Ñ¡Aµo²{.... ·|¤£·|¬O±zqueryªºvalue¤Ó¤j ©Ò¥Hcommandtext©ñ¤£¤U... |
|
Y¬O§Ú¦^µª¡A¨Ï±zº¡·N¡A½Ð±zÅý§Úª¾¹D¡I
Y¬O§Úªº¦^ÂСA±z¤´¦³¨ä¥L¨£¸Ñ¡A¤]½Ð±z¤£¶Þ«ü±Ð¡I
|
|
|
|
|
- ©«¤l
- 172
- ¥DÃD
- 39
- ºëµØ
- 20
- ¿n¤À
- 177
- ÂI¦W
- 0
- §@·~¨t²Î
- Microsoft Windows XP
- ³nÅ骩¥»
- Microsoft Office 2003
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- °ª¶¯
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2023-3-19
|
|
Y¬O§Ú¦^µª¡A¨Ï±zº¡·N¡A½Ð±zÅý§Úª¾¹D¡I
Y¬O§Úªº¦^ÂСA±z¤´¦³¨ä¥L¨£¸Ñ¡A¤]½Ð±z¤£¶Þ«ü±Ð¡I
|
|
|
|
|
- ©«¤l
- 172
- ¥DÃD
- 39
- ºëµØ
- 20
- ¿n¤À
- 177
- ÂI¦W
- 0
- §@·~¨t²Î
- Microsoft Windows XP
- ³nÅ骩¥»
- Microsoft Office 2003
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- °ª¶¯
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2023-3-19
|
¦^´_ Min
½Ð°Ýª©¥D¡A§A¥Îªº¬Omysql¡A¤p§Ì¬O«üsql server
¤p§Ìªº¥D¾÷¡Gtest
±b¸¹¡Gabc
±K½X¡G12 ...
joey0415 µoªí©ó 2010/6/30 12:32 AM
1.
sql server connection½d¨Ò¦p¤U
Cnnl.Open "Provider=MSIDXS.1; Data Source=path to file Indexing Service"
2.
SQL ½Ð±z¬Ý²Ä¤Q¦æ~
3.
¦Ü©óSQLªºªøµu...
¤£À´±zªº·N«ä!
¦pªG¬O«ü queroªº¸ê®Æ ¨º¶ëÃzexcel¨S°ÝÃD.. ¦ý¶ëÃz¦]¸Ó¨S¦³·N¸q... ©Ò¥H¦]¸Ó¬O¥u¯à©ñ65535*255!
¨º¦pªG±z«üªº¬OsqlÅÜ¼Æ ªøµu°ÝÃD.. ¨º¥i¥H¬d¤@¤Ustring¤W~ |
|
Y¬O§Ú¦^µª¡A¨Ï±zº¡·N¡A½Ð±zÅý§Úª¾¹D¡I
Y¬O§Úªº¦^ÂСA±z¤´¦³¨ä¥L¨£¸Ñ¡A¤]½Ð±z¤£¶Þ«ü±Ð¡I
|
|
|
|
|