DelphiʹÓÃSQL ServerÈçºÎ¿ÉÒÔ²»°²×°SQLServer2000
ÈçÌâËùʾ
СµÜʹÓÃDelphi7»·¾³½øÐÐÊý¾Ý²É¼¯£¬²É¼¯µ½µÄÊý¾Ý·ÅÈëSQL Server2000Êý¾Ý¿âÖУ¬µ«ÊÇÏë²»°²×°SQLServer2000À´ÊµÏÖ´ÓÆäËü¼ÆËã»úÉÏÔËÐд˳ÌÐò£¬²»ÖªÈçºÎʵÏÖ£¿Íû¸÷λ´óϺ¸æÖªÒ»¶þ¡£
ÁíÍ⣬ÏÖÔÚСµÜÓöµ½ÁËÒ»¸öÎÊÌ⣬ʹÓÃADOÁ¬½ÓÊý¾Ý¿â£¬ÔÚÆäËü×°ÓÐSQLServer2000µÄ»úÆ÷ÉÏʹÓÃʱ£¬ÀÏÊǵ¯³öÊý¾Ý¿âÁ¬½Ó´íÎóµÄÌáʾ£¬²»ÖªÈçºÎ½â¾ö£¿Äܽâ¾ö´Ë¶þÕßÎÊÌâÖ®Ò»µÄ´óϺ¸øÈ«·Ö£¬Ð»Ð»À²£¡
°Ýл£¡£¡£¡
Çë¸÷λ´óϺ½«²»Óð²×°SQLserverµÄ·½·¨ÏêϸµÄ˵һÏ£¬Ð»Ð»À²£¡
midas£¬×öÒ»¸ö·þÎñÆ÷³ÌÐò
û¿´Ã÷°×ÄãÒª¸ÉÂÊÇ¿Í»§¶Ë²»×°SqlServerÂð£¬ÕâÊ¿ÉÒÔʵÏֵģ¬Ö»Ð輸¸ödll´ò°ü½øÈ¥¾ÍÐÐÁË
win2000£¨»ò¸ü¸ß°æ±¾£©¼°°²×°ÁËoffice2000£¨»ò¸ü¸ß°æ±¾£©µÄϵͳ£¬¶¼²»Óð²×°sql2000¼´¿ÉÒÔ·ÃÎʱðµÄ»úÆ÷ÉϵÄsql2000Êý¾Ý¿â
ÎÒû˵Çå³þ£¬²»ºÃÒâ˼£¬ÊÇÕâÑùµÄ£¬ÎÒÓõÄDelphi±àдµÄ³ÌÐò²É¼¯Êý¾Ý£¬Êý¾Ý´æÈëSQLserver2000Êý¾Ý¿âÖУ¬È»ºóÎÒÏë°ÑÎÒ±àдµÄ³ÌÐòºÍÊý¾Ý¿âÎļþ¿½µ½±ðµÄ»ú×ÓÉÏÒ²ÄÜÕý³£Ê¹Óã¬Ä¿±ê»ú²»°²×°SQLserver2000£¬²»ÖªµÀÔõÑùʵÏÖ¡£
»»accessÖ®ÀàµÄÎļþÐ͵İÉ,Èç¹ûÄãÏë°ÑÊý¾Ý¶¼´ø×Å,ÄÇ»ù±¾ÉÏ×°¸ö·þÎñ³ÌÐòÊDZØÒªµÄ,´Ósqlserver2K,µ½MSDE
1¡¢Ê¹ÓÃACCESS»òÆäËü×ÀÃæÊý¾Ý¿â¿ÉÃâ°²×°Ö®ÈÅ£¬µ«Ç°ÌáÒª¿´ÄãµÄÊý¾ÝÁ¿µÈÐèÇóÇé¿ö
2¡¢Èç¹ûÈÔʹÓÃSQL Server£¬¿É¿¼ÂÇÆä×ÀÃæ°æ£¨MSDE£¬2005Ö®ºó³ÆΪExpress Edition£©
²»´óÃ÷°×
»Ø¸´ÄÚÈÝÌ«¶ÌÁË£¡ »Ø¸´ÄÚÈÝÌ«¶ÌÁË£¡ »Ø¸´ÄÚÈÝÌ«¶ÌÁË£¡
XP²»ÓÃװʲô£¬WINDOWS2000¼°ÒÔÏ¿ÉÒÔ°²×°MSADO 2.7
Èç¹ûÖ»ÊÇ¿Í»§¶ËÓÃodbc»òADO¿ÉÒÔ²»°²×°SQL SERVER¿Í»§¶Ë
Èç¹ûÒªÊÇÓÃÊý¾Ý¿â·þÎñÆ÷,²»×°sqlserver ¿ÉÒÔ×°Ò»¸öMSDE(Microsoft SQL Server Desktop Engine)
Èç¹ûÒ»¶¨Ò
Ïà¹ØÎÊ´ð£º
hongqi162¡¢windindance
´Ë2È˳¤ÆÚ²»ÔÚÏߣ¬ÌرðÊÇwindindance
¸ü»»ÓÐÄÜÁ¦µÄÈËÉÏ
hongqi162»¹ÊǾ³£ÉÏÀ´×ª×ªµÄ
ÒýÓÃ
¸ü»»ÓÐÄÜÁ¦µÄÈËÉÏ
ÆäʵҲ²»ÊÇʲôÄÜÁ¦µÄÔÒò£¬Ö÷Òª¿ÉÄÜÊÇʱ¼äÎÊÌâ°É
¹¤×÷µÄ»¹ÒªÉÏ°à£¬Ñ§Ï ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄÇ°2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬
sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º
ÈÕÆÚ 2010-1-25 14:45: ......
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......