Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ado·ÃÎÊÔ¶³ÌÊý¾Ý¿â(Ô¶³Ì·ÃÎÊsqlserver)

ÊÇÕâÑùµÄ£¬ÎÒÓÃÊÇODBCÊý¾ÝÔ´Á¬½Ó·þÎñÆ÷µÄÊý¾Ý¿â£¬ÏÖÔÚÎÒ¾õµÃºÜÂé·³£¬ÒòΪҪΪÿÈç»úÌí¼Ó¶ÔÓ¦µÄÊý¾ÝÔ´£¬Ïë°ÑËû¸Ä³ÉADO·½·¨À´·ÃÎÊ·þÎñÆ÷µÄÊý¾Ý¿âÄÜʵÏÖÂð£¿ÒªÔõôд¡£
±ÈÈç·þÎñÆ÷ÀïÓжþ¸öÊý¾Ý¿âdata1 ºÍdata2£¬¿Í»§¶ËÕâ±ßÎÒÉÏÓÃACESSS\vbaÀ´×ö³ÌÐò£¬ÒªÔõô²ÅÄÜÁ¬½Ó·ÃÎʵ½ÎÒ·þÎñÆ÷ÀïÃæµÄÁ½¸öÊý¾Ý¿âµÄÊý¾ÝÄØ£¿Ð»Ð»
http://hi.baidu.com/jjg0513/blog/item/23174d551c795ecdb745aef5.html

²Î¿¼ÏÂ

Ò»´ÎÖ»ÄÜÒ»¸ö.

±ÈÈç·þÎñÆ÷ÀïÓжþ¸öÊý¾Ý¿âdata1 ºÍdata2

ÄãÓÃADOÁ¬½ÓÖ±½Ó·ÃÎÊÄãµÄ·þÎñÆ÷

ΪʲôҪÊÇACCESSµÄ

Â¥ÉÏÄãÌ«¸ãЦÁ˰ɡ£ÄãµÄÒâ˼ÊÇSQLÖ»Äܽ¨Ò»¸öÊý¾Ý¿âà¶

ÒýÓÃ
Â¥ÉÏÄãÌ«¸ãЦÁ˰ɡ£ÄãµÄÒâ˼ÊÇSQLÖ»Äܽ¨Ò»¸öÊý¾Ý¿âà¶


ÎÚ¹êµÄÒâ˼ÊÇÒ»´ÎÖ»ÄÜÁ¬½ÓÒ»¸öÊý¾Ý¿â

ÓÃÁ½¸öÁ¬½ÓÀ´Á¬

Ôõô¸öÁ¬½Ó·¨£¬Ëµ¾ßÌåÒ»µãß¹¡£¡£¸ßÊÖÃÇ


Ïà¹ØÎÊ´ð£º

¹ØÓÚSQLSERVERµ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......

sqlserver 1433¶Ë¿ÚµÄÎÊÌâ(ÕûÁËÒ»ÌìÎÞ¹û,¶¥Ò²ÓзÖ)

xp(sp3)ϵͳ°²×°ÁËsqlserver2000£¬sp3£¬sp4²¹¶¡¶¼´òÁË¡£¶øÇÒ±¾»úÒ²ÄÜÁ¬½Ó·ÃÎÊ¡£
ÎÊÌâÊÇ£º
±¾»útelnet ip 1433 ×ÜÊÇÌáʾÁ¬½Óʧ°Ü£¬
¶øÇÒnetstat -naʱ£¬¿´²»µ½1433¶Ë¿Ú±»Õ¼ÓÃ
(¿Ï¶¨µÄÊÇ£º¶Ë¿ÚÊÇ1433£¬¿ªÆ ......

sqlserver£¬ÄľäsqlÓï¾ä¸ü¿ì£¿

±ísinger£º
singerID£¬singerName
1£¬ÁõµÂ»ª
2£¬ÕÅѧÓÑ
3£¬¹ù¸»³Ç
4£¬ÀèÃ÷

±ísong£º
songID£¬songName£¬singerID
1£¬ÍüÇéË®£¬1
2£¬ÖйúÈË£¬1
3£¬ÎDZð£¬2
4£¬¶ÔÄã°®²»Í꣬3
......

vfpÈçºÎ¶ÁÈ¡SQLServer×Ö¶ÎÖеÄͼƬ£¿

ÔõôÔÚvfpµÄ±íµ¥ÖÐÏÔÏÖ´ÓsqlserverÖÐ×¥¹ýÀ´µÄͼƬ£¿

ÎÒÓõÄÊÇvfp6.0

Ìý˵¿ÉÒÔµ÷ÓÃÆäËûÓïÑÔдµÄdllÀ´ÊµÏÖ£¬
ÎÒ¿ÉÒÔÓÃdelphiдdll³öÀ´£¬
µ«ÊÇÎÒ²»»áÓÃʹÓÃvfpÀ´µ÷ÓÃdll°¡

Õâ¶Î´úÂëÊÇ´ÓSQLSEREVR¡¡I ......

ÔÚÖ¸¶¨µÄλÖò»´æÔÚÓÐЧµÄSQLServer°²×°

°²×°SQLServer2000¸öÈ˰棬µ½¡°°²×°ÀàÐÍ¡±½çÃæ£¬²»¹ÜÑ¡ÔñʲôѡÏ²»¹ÜÓÃĬÈÏ·¾¶»¹ÊÇ×Ô¶¨Òå·¾¶£¬µã»÷ÏÂÒ»²½£¬¶¼µ¯³ö¡°ÔÚÖ¸¶¨µÄλÖò»´æÔÚÓÐЧµÄSQLServer°²×°—C:\Program Files\Microsoft SQL Server¡±µÄ¶Ô ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ