ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

°õ¦æ¶¥¬q¿ù»~13 «¬ºA¤£²Å¦X

±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

TOP

¤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

TOP

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

TOP

¦^´_  Min


    ·|¤£·|¬O±zqueryªºvalue¤Ó¤j ©Ò¥Hcommandtext©ñ¤£¤U


¤p§Ì¤]ı±o¬O¦p¦¹¡A¦ý¬O¤p§Ì ...
joey0415 µoªí©ó 2010/6/29 02:03 PM



¤£¦n·N«ä §Ú¤]¨S¥Î¹L±z³oºØ¤è¦¡¦s¨úDataBase
¦ý±z¥i¥H°Ñ¦ÒADOªº¤è¦¡ http://forum.twbts.com/viewthread.php?tid=712&extra=
­Y¬O§Ú¦^µª¡A¨Ï±zº¡·N¡A½Ð±zÅý§Úª¾¹D¡I                  
­Y¬O§Úªº¦^ÂСA±z¤´¦³¨ä¥L¨£¸Ñ¡A¤]½Ð±z¤£¶Þ«ü±Ð¡I

TOP

¦^´_  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

TOP

        ÀR«ä¦Û¦b : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD