|
VFP ·R¥ÎªÌªÀ°Ï ¥»°Q½×°Ï¬° Visual Foxpro ·R¥ÎªÌ¸gÅç¥æ¬yªº¦a¤è, ½Ð¦h¦h§Q¥Î"·j´M"ªº¥\¯à, ¥ý¬d¬Ý¬Ý¦³µL«e¨Ò¥i´`, ¦pªGÁÙ¦³¤£À´ªº¦Aµo°Ý. ³¡¥÷¥DÃD¦³ªþ¥[ÀÉ®×, ¶·¥ýµù¥U¦¨¬°ªÀ°Ï©~¥Á¤~¥i¥H¤U¸ü.
|
¤W¤@½g¥DÃD :: ¤U¤@½g¥DÃD |
µoªí¤H |
¤º®e |
¦¶¨|¿³
µù¥U®É¶¡: 2003-08-25 ¤å³¹: 661 ¨Ó¦Û: ¥x¤¤¥«¤j¨½°Ï
²Ä 1 ¼Ó
|
µoªí©ó: ¬P´Á¥| ¤G¤ë 07, 2008 10:29 pm ¤å³¹¥DÃD: ½Ð°Ý¡G¦p¦ó±N VFP ªº¸ê®Æ·s¼W¨ì SQL Server ¤¤¤§³t«×¥[§Ö |
|
|
¦U¦ì¡A·s¦~§Ö¼Ö¡A§Ú¦³¤U¦C°ÝÃD·Qn½Ð±Ð¡G
§Ún±N VFP ªº¸ê®Æ¤@¦¸¾ã§å·s¼W¨ì SQL Server ¤¤¡A§ÚÁöµM·s¼W¸ê®Æ¬O¨S°ÝÃD¡A¦ý³t«×¹ê¦b¬O¤ÓºC¤F¡A¥§¡ 1 ¤ÀÄÁ¤~¤j¬ù·s¼W¤F 56 µ§¡A³oºØÀt³t¹ê¦b¬OµLªk§Ô¨ü¡A§Ú»{¬°µ´¹ï¬O§Úªº¼gªk«ÜÄê¡C¦ýªì¦¸ºN SQL Server¡A©Ò¥H·Q½Ð±Ð¦U¦ì¦Ñ¸gÅ窺ª°¤ÍÌ¡A«üÂI¤@¤U§Ú³oÓªì¤J SQL Server ÂOªL¤¤ªºµæ³¾¡C§Úªºµ{¦¡½X¦p¤U¡G
* °²³]
*
* TMP_VFPTable ¬O VFP ªº Table
* ¡@Äæ¦ìµ²ºc¬O Field1 C(10), Field2 N(9), Field3 D ,Field4 M
*
* TMP_SQLTable ¬O SQL Server ªº Table (ùر©|¥¼¦³¥ô¦ó¸ê®Æ)
* ¡@Äæ¦ìµ²ºc¬O Field1 char(10), Field2 float(9), Field3 datetime, Field4 text
*
* ì«h¤W¤Wz¨âÓÄæ¦ìµ²ºc¬O¤@P©Êªº
*
* M_nConnectHandle ¬O¤@Ó¤w³s±µ¨ì SQL Server ªº³s±µ±±¨î½X
* TMP_SQLTable ©Ò¦bªº¸ê®Æ®w¤w³]©w¬°§@¥Î¸ê®Æ®w(SQL Server ¤¤)
*
* SQL Server ¬O¸Ë¦b¥»¾÷¤W
M_eFieldValue1 = ""
M_eFieldValue2 = 0
M_eFieldValue3 = DATE()
M_eFieldValue4 = ""
=SQLPREPARE(M_nConnectHandle,"INSERT INTO TMP_SQLTable VALUES (?M_eFieldValue1, ?M_eFieldValue2, ?M_eFieldValue3, ?M_eFieldValue4)")
SELECT 0
USE TMP_VFPTable
SCAN ALL
M_eFieldValue1 = Field1
M_eFieldValue2 = Field2
M_eFieldValue3 = Field3
M_eFieldValue4 = Field4
=SQLEXEC(M_nConnectHandle)
ENDSCAN
USE IN TMP_VFPTable
---------------------------------------------------------------
¤WzÃþ¦ü³o¼Ëªº¼gªk¡A¦P¤@§å¸ê®Æ¡A¦b§Úªº NB (3 ¦~¦h«e¶Rªº¡AµwºÐ¦³ 30 GB¡A³Ñ¾lªÅ¶¡¥u³Ñ 2,85 GB) ¤W¡A329 µ§¸ê®Æ¶]¤F 5 ¤À 52 ¬í
¦ý¦b§Ú¤½¥q¨Ï¥Îªº PC (À³¸Ó¬O 1 ¦~¤º¶Rªº¡AµwºÐªº³Ñ¾lªÅ¶¡¨¬°÷)¡A¶]¦P¼Ëªºµ§¼Æ¤j¬ù 1 ¬í (¦ý¶]«D±`¤j¶qªº¸ê®Æ¡A·Pı¤W¤]¬On¶]«Ü¤[)
§Úªº·Qªk¬O¡A´Nºâ§Úªº NB ¦AºC¡A¦ý¤]¤£À³¸ÓºC¦¨³o¼Ë¡A¬O¤£¬O§ÚÁÙn³]©w¤@¨Ç¬ÛÃöªºÀô¹Ò¡A¨Ò¦p¹³¡G²§°Ê¥æ°Ê¡B½w½Ä³B²z ... µ¥µ¥ªº³]©w¡C _________________ §Æ±æ¦³§ó¦h¤H¨Ó°Ñ»P
VFP wiki - »Ýn¤j®a¤@°_§¹¦¨ªºVFP¹q¤l®Ñ»PFAQ |
|
¦^³»ºÝ |
|
|
pingoleo
µù¥U®É¶¡: 2004-04-12 ¤å³¹: 92
²Ä 2 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤G¤ë 12, 2008 7:32 am ¤å³¹¥DÃD: |
|
|
«Ü¤Ö¬Ý¨ìª°¤Í¥Î remote view §Ú¥Îremote view ¶] msde
³t«×¬O¥i¥H±µ¨üªº ´X¸Uµ§¸ê®Æ´X¤ÀÄÁ´NOK ¤F
§Úªº RAM 512MB CPU ÁÉ´ 2.2G (4,5 ¦~ªº¦Ñ¦©¦©¾÷¤F) |
|
¦^³»ºÝ |
|
|
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4212 ¨Ó¦Û: Taipei,Taiwan
²Ä 3 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤G¤ë 12, 2008 10:44 am ¤å³¹¥DÃD: |
|
|
³oºØ¼gªk¬OÁÙ¦n,
¤]¤£¨£±o«D±o¥ý prepare ¤@¤U,
ÁöµM®Ñ¤W³£³o¼Ë»¡,
¥i¯à»Ýn´X¤Q¸Uµ§¤~·|·Pı¤ñ¸û§Ö.
sql server ªº³]p¨Ó»¡,
¸ê®ÆºûÅ@ªº³t«×¤ñ¬d¸ß¸ê®Æªº³t«×ºC«Ü¦h,
°t¸m¸ê®Æ®wªÅ¶¡ºC,°t¸mtable ¤]ºC,
ºûÅ@index ¤]ºC.
¦pªG§A¨S¦³³]©wtranction,
sql server ¤@¯ë·|¶i¦æÁô§tªº¥æ©ö³B²z,
¤]´N¬O³vµ§¸ê®Æ³£°µ¥æ©ö³B²z,
·íµM¤ÏÀ³·|µy·LºC¨Ç.
§A¥i¥H¦bsqlexec() ©Î sqlprepare()«e«á¥[¤W timer() ¬Ý¬Ý,
³o¨âÓ¬O«áºÝsql ©R¥O,
¨Ã¤£¯A¤Î¥»¦aºÝ²§°Ê¥æ©ö³B²z¤Î½w½Ä³B²z,
©Ò¥H®É¶¡®t´N¬Osql server ¯Âºé°õ¦æ©R¥Oªº³t«×. _________________ ¦pªG¤½¥q¦³¤U¦C§xÂZ:
1. §ä¤£¨ì«K©y,§Ö³t,²©öªº ¥Í²£±Æµ{³nÅé
2. ¤£ª¾¹D¦p¦ó§Ö³t±Æ©w ±ÄÁÊp¹º
3. ¦¨¥»§ì¤£·Ç,¦Û¤vºâ¤ñ³nÅéºâ¦³¥Î
4. ·Q¾Ç²ß¨t²Î³W¹º,·Q§ä¨t²Î¬[ºcªºÅU°Ý
½ÐÁpµ¸§ÚÌ,¤]³\§ÚÌÀ°±o¤W¦£ |
|
¦^³»ºÝ |
|
|
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4212 ¨Ó¦Û: Taipei,Taiwan
²Ä 4 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤G¤ë 12, 2008 10:52 am ¤å³¹¥DÃD: |
|
|
´NµwÅé¤è±¦Ó¨¥,
§ANB ªº30G µwºÐ¬O¦h¤ÖÂ઺,
¦pªG¬O 4200 Âà,seek time ¹ê¦b¤Óªø¤F,
ÄY«©ì²Ö³t«×,
¦w¸Ë¤F¦h¤Ö°O¾ÐÅé?
sqlserver ¦û¥Îªº°O¾ÐÅ馳¦h¤Ö?
·|¤£·|¥X²{¤@ª½¦bµêÀÀ°O¾ÐÅé swap in/out ªº°Ê§@.
³Ñ¤UªÅ¶¡¤]¥i¯à¤£°÷OS¤Îsqlserver ¹BÂà. _________________ ¦pªG¤½¥q¦³¤U¦C§xÂZ:
1. §ä¤£¨ì«K©y,§Ö³t,²©öªº ¥Í²£±Æµ{³nÅé
2. ¤£ª¾¹D¦p¦ó§Ö³t±Æ©w ±ÄÁÊp¹º
3. ¦¨¥»§ì¤£·Ç,¦Û¤vºâ¤ñ³nÅéºâ¦³¥Î
4. ·Q¾Ç²ß¨t²Î³W¹º,·Q§ä¨t²Î¬[ºcªºÅU°Ý
½ÐÁpµ¸§ÚÌ,¤]³\§ÚÌÀ°±o¤W¦£ |
|
¦^³»ºÝ |
|
|
¦¶¨|¿³
µù¥U®É¶¡: 2003-08-25 ¤å³¹: 661 ¨Ó¦Û: ¥x¤¤¥«¤j¨½°Ï
²Ä 5 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤G¤ë 12, 2008 12:35 pm ¤å³¹¥DÃD: |
|
|
ÁÂÁ¦U¦ì¦^ÂСA³o´X¤Ñ¦b®a¤@ª½´ú¸Õ¡A¦P¼Ëªºµ{¦¡¤µ¤Ñ®³¨ì¤½¥q¨Ó¶]¡A³t«×¤W¬O¥i±µ¨üªº¡F©Ò¥H¦^®a§â NB ùتº SQL Server «Äé¤@¦¸¬Ý¬Ý¡A¦]¬°¦n¹³·íªì¸Ë SQL Server ªº¹Lµ{¤¤¡A¤£¬O«Ü¶¶§Q¡A¤]§Æ±æ¬O¦¹°ÝÃD¡C¦]¬°°Ñ¦Ò¹L¦UºØ¸ê®Æ¡Aì«h¤W¼gªkÀ³¸Ó¨S¦³¤°»ò¤j°ÝÃD¤~¹ï¡C _________________ §Æ±æ¦³§ó¦h¤H¨Ó°Ñ»P
VFP wiki - »Ýn¤j®a¤@°_§¹¦¨ªºVFP¹q¤l®Ñ»PFAQ |
|
¦^³»ºÝ |
|
|
¦¶¨|¿³
µù¥U®É¶¡: 2003-08-25 ¤å³¹: 661 ¨Ó¦Û: ¥x¤¤¥«¤j¨½°Ï
²Ä 6 ¼Ó
|
µoªí©ó: ¬P´Á¤T ¤G¤ë 13, 2008 4:38 pm ¤å³¹¥DÃD: |
|
|
¤µ¤Ñ¦b¤½¥qªº¹q¸£¤W¡A©ó¥»¾÷¤¤¤W¶Ç SQL Server¡A´ú¸Õµ²ªG
232 ÓÀÉ®×(DBF)¦@ 1,430,394 µ§°O¿ý»Ý¶O®É 00:42:01 §¹¦¨¡A¥§¡ 34,057 µ§°O¿ý/min
³o¼Ëªº³t«×¬O¥i¥H¶Ü¡H¦pªGn¦A§Ö¡AþùØÁÙ¥i¥H¦A§ï¨} _________________ §Æ±æ¦³§ó¦h¤H¨Ó°Ñ»P
VFP wiki - »Ýn¤j®a¤@°_§¹¦¨ªºVFP¹q¤l®Ñ»PFAQ |
|
¦^³»ºÝ |
|
|
garfield Site Admin
µù¥U®É¶¡: 2003-01-30 ¤å³¹: 2157
²Ä 7 ¼Ó
|
µoªí©ó: ¬P´Á¤T ¤G¤ë 13, 2008 5:41 pm ¤å³¹¥DÃD: |
|
|
¦³¨S¦³·Qn¸Õ¬Ý¬Ý remote view
©Î³\·|§Ö¤@ÂI. _________________ §Q¥Î>>·j´M<<ªº¥\¯à·|¤ñ°ÝªºÁÙn§Ö±o¨ìµª®×. |
|
¦^³»ºÝ |
|
|
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4212 ¨Ó¦Û: Taipei,Taiwan
²Ä 8 ¼Ó
|
µoªí©ó: ¬P´Á¥| ¤G¤ë 14, 2008 9:41 am ¤å³¹¥DÃD: |
|
|
±Ð¬ì®Ñ¤W¬O»¡,
bulk insert µ¥¤j¶q½Æ»s¨ç¦¡©Î¬O bcp ¤½¥Îµ{¦¡,
¬O¥Î¨Ó°µ¤j¶q½Æ»sªº.
¶Ç²Îªº xbase ªº§@ªk,
¥ý²¾°£ index,
¦bappend §¹«á,¦A¥[¤Jindex,
¤£ª¾¹D¦¨®Ä¦p¦ó. _________________ ¦pªG¤½¥q¦³¤U¦C§xÂZ:
1. §ä¤£¨ì«K©y,§Ö³t,²©öªº ¥Í²£±Æµ{³nÅé
2. ¤£ª¾¹D¦p¦ó§Ö³t±Æ©w ±ÄÁÊp¹º
3. ¦¨¥»§ì¤£·Ç,¦Û¤vºâ¤ñ³nÅéºâ¦³¥Î
4. ·Q¾Ç²ß¨t²Î³W¹º,·Q§ä¨t²Î¬[ºcªºÅU°Ý
½ÐÁpµ¸§ÚÌ,¤]³\§ÚÌÀ°±o¤W¦£ |
|
¦^³»ºÝ |
|
|
cchvfp
µù¥U®É¶¡: 2003-07-05 ¤å³¹: 18
²Ä 9 ¼Ó
|
µoªí©ó: ¬P´Á¥| ¤G¤ë 14, 2008 11:50 am ¤å³¹¥DÃD: |
|
|
«ç»ò¤£¥Îsqlªº¶×¤J |
|
¦^³»ºÝ |
|
|
¦¶¨|¿³
µù¥U®É¶¡: 2003-08-25 ¤å³¹: 661 ¨Ó¦Û: ¥x¤¤¥«¤j¨½°Ï
²Ä 10 ¼Ó
|
µoªí©ó: ¬P´Á¥| ¤G¤ë 14, 2008 2:16 pm ¤å³¹¥DÃD: |
|
|
³o¬O·L³n´£¨Ñªº¡A¬Ý¼Ë¤ln¬ã¨s¬ã¨s¤@¤U bcp¡A¦]¬°ÁÙ¤£¤Ó¤F¸Ñ«ç»ò¥Î bcp
http://support.microsoft.com/kb/153199/zh-tw
¦p¦ó¨Ï¥Î SQL Server ¤j¶q½Æ»sµ{¦¡¡A ±q Visual FoxPro ¤j¶qªº¸ê®Æ²¾°Ê¨ì SQL Server
¤å³¹½s¸¹ : 153199
¤W¦¸®Õ¾\ : 2007¦~2¤ë12¤é
ª©¦¸ : 4.1
µ²½×
¥»¤å§i¶D±z¦p¦ó¨Ï¥Î¤j¶q½Æ»sµ{¦¡ (BCP)¡A ¿W¥ßªº¤½¥Îµ{¦¡ÀHªþªº Microsoft SQL Server¡C ¦pªG±z¥²¶·¦P®É²¾°Ê¤j¶qªº¸ê®Æ¦Ü SQL Server¡A ±q Microsoft Visual FoxPro ¡u SQL Âà´«ºëÆF ¡v ¥i¯à·|¤ÓºC¡C Bulk Copy Program ¤½¥Îµ{¦¡¥u¯à¶Ç°e¸ê®Æ¡A ¥¦´N¤£·|«Ø¥ß¸ê®Æªí¡C ±z¥i¥H¨Ï¥Î ¡u SQL Âà´«ºëÆF ¡v ¨Ó«Ø¥ß¸ê®Æªí©Î«Ø¥ß±z¦Û¤v¦b ISQL / W¡C ¬°¤Fn·Ç³Æ SQL ¦øªA¾¹¡A ¥H±µ¨ü (Accept) ¨Ï¥Î ¡u §Ö³t ¡v ª©¥»ªº BCP¡A ¸ê®Æ±z¥²¶·°õ¦æ sp_dboption ¨t²Îµ{§Ç¨Ã±N select into / bulkcopy ¿ï¶µ¡A «h¬° True
³v¨B»¡©ú½d¨Ò
¥H¤U¬O½d¨Ò¨BÆJ¨Ï¥Î BCP ¤½¥Îµ{¦¡¡A ±N¸ê®Æ±q¤@Ó ASCII Àɮ׶ǰe¦Ü SQL Server¡G
1. ±q SQL Server °õ¦æ¡G
sp_dboption Mydatabase,bulkcopy,true
2. ±q Visual FoxPro ¸ê®Æªí«Ø¥ß©w¦ìÂI¤À¹j ASCII ÀɮסC Á|¨Ò¨Ó»¡¡A ½Ð¨Ï¥Î§C¶¥ªº±`¦¡¡A ¥H¿é¥X¨ì¤å¦rÀɪºÄæ¦ì¡G
=FPUTS(fhandle, emp_id + CHR(9) + ;
last_name + CHR(9) + ;
first_name + CHR(9) + ;
title + CHR(9) + ;
PADR(DTOC(birth_date)+' '+'12:00AM',16,' ') + CHR(9) + ;
PADR(DTOC(hire_date)+' '+ '12:00AM',16,' ') + CHR(9) + ;
address + CHR(9) + ;
city + CHR(9) + ;
region + CHR(9) + ;
postalcode + CHR(9) + ;
STR(salary,12,2) )
3. «Ø¥ß bcp ®æ¦¡Àɮפ~¯à¶Ç°e¸ê®Æ¡C ¨Ò¦p¡A ±q SQL Server ¤U bin ¥Ø¿ý¡G
bcp mydatabase.dbo.employee ¥X c:\temp\emp.txt /Sservename /Usa /Ppassword
ª`·N¡G ³oÓ©R¥OÀ³¸Ó¬O¦b¦P¤@¦æ¡C
4. ½Ð¿í´`´£¥Ü¡A ©M«¬§O \t ¦p¬°¨CÓÄæ¦ìÄæ¦ì²×ºÝ¤l¡C
5. ¥X²{´£¥Ü®É¡A ¨Ï¥Î¦³·N¸qªº¦WºÙ¡A ¨Ò¦p employee.fmt Àx¦s®æ¦¡ÀɮסC
6. ¨Ï¥Î MS - DOS ½s¿è¾¹¨Ó½s¿è . ®æ¦¡ÀÉ¡C
7. ¦b¤U¦C½d¨Ò¨Ï¥Î employee.fmt ¬°Åܧ󬰨CÓ¸ê®Æ¦C²Ä¤GÄ欰 SYBCHAR¡G
6.0
11
1 SYBCHAR 0 6 "\t" 1 emp_id
2 SYBCHAR 0 20 "\t" 2 last_name
3 SYBCHAR 0 10 "\t" 3 first_name
4 SYBCHAR 0 30 "\t" 4 title
5 SYBCHAR 0 16 "\t" 5 birth_date
6 SYBCHAR 0 16 "\t" 6 hire_date
7 SYBCHAR 0 60 "\t" 7 address
8 SYBCHAR 0 15 "\t" 8 city
9 SYBCHAR 0 15 "\t" 9 region
10 SYBCHAR 0 10 "\t" 10 postalcode
11 SYBCHAR 0 8 "\r\n" 11 salary
8. ÀÉ®×µ²§À (EOF) ¼Ð°O¬°Åܧó²Ä¤¸ê®Æ¦æ¤¤ªº³Ì«á¤@¦C¬° "\ \ n "¡C
9. ±N ASCII Àɮ׶ǿé¦Ü SQL Server ¨Ï¥Î BCP ¦p¤U©Ò¥Ü¡G
¦b c:\temp\employ.txt /femployee.fmt /Sservernamec /Usa / P bcp mydatabase.dbo.employee " "
10. ¦^¬°¨Ï¥Î¨BÆJ 1 ¥H FALSE °Ñ¼Æ FALSE¡A §¹¦¨®É³]©w Bulkcopy ¿ï¶µ¡C
ƒò¦Ò
¦p»Ý¸Ô²Ó¸ê°T¡A ½Ð°Ñ¾\ SQL Server Administrator ' s ¨t²Î Guide¡C
--------------------------------------------------------------------------------
³o½g¤å³¹¤¤ªº¸ê°T¾A¥Î©ó:
• Microsoft Visual FoxPro 3.0 Standard Edition
• Microsoft Visual FoxPro 3.0b Standard Edition
• Microsoft Visual FoxPro 6.0 Professional Edition
• Microsoft Visual FoxPro 7.0 Professional Edition
• Microsoft Visual FoxPro 8.0 Professional Edition
• Microsoft Visual FoxPro 9.0 Professional Edition
ÃöÁä¦r¡G kb3rdparty kbhowto kbinterop KB153199 KbMtzh kbmt _________________ §Æ±æ¦³§ó¦h¤H¨Ó°Ñ»P
VFP wiki - »Ýn¤j®a¤@°_§¹¦¨ªºVFP¹q¤l®Ñ»PFAQ |
|
¦^³»ºÝ |
|
|
|
|
±z µLªk ¦b³oÓª©±µoªí¤å³¹ ±z µLªk ¦b³oÓª©±¦^ÂФ峹 ±z µLªk ¦b³oÓª©±½s¿è¤å³¹ ±z µLªk ¦b³oÓª©±§R°£¤å³¹ ±z µLªk ¦b³oÓª©±¶i¦æ§ë²¼ ±z µLªk ¦b³oÓª©±ªþ¥[ÀÉ®× ±z µLªk ¦b³oÓª©±¤U¸üÀÉ®×
|
Powered by phpBB © 2001, 2005 phpBB Group ¥¿Å餤¤å»y¨t¥Ñ phpbb-tw ºûÅ@»s§@
|