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

PB Êý¾Ý¿âÁ¬½ÓÒÔ¼°sqlÓï¾äÔËÐÐÐÅÏ¢·µ»Ø´úÂë½âÊÍ´óÈ«


Èç¹ûÒ»¸ö SQL Óï¾ä·¢ÉúÁË´íÎó£¬ÄÇô sqlca.sqlcode ½«ÊÇ·ÇÁãÖµ¡£
Èç¹û sqlca.sqlcode СÓÚ 0 ÄÇô¾ÍÊÇ·¢ÉúÁËijÖÖÑÏÖØµÄ´íÎó£¬ÏóÊý¾Ý¿â¶¨ÒåÓë²éѯ¶¨Òå²»Ò»Öµȣ®
Èç¹û´óÓÚ 0 ÔòÊÇͨ³£µÄ´íÎó£¬Ïó±í²»°üÀ¨ËùÒªÇóµÄÐеȣ®
sqlca.sqlcode == 0£¬³É¹¦
sqlca.sqlcode == -1 ʧ°Ü     £¨»ñÈ¡¾ßÌåʧ°ÜÐÅÏ¢£ºmessagebox('',"³ö´íÐÅÏ¢:"+sqlca.SQLErrText) £©--PBÀïµÄ²Ù×÷·½·¨
sqlca.sqlcode == 100, Data not found line %d.
ÕâÊÇÒ»¸ö"Õý³£µÄ"´íÎ󣬸æËßÄãÄãÕýÔÚ²éѯµÄ¶«Î÷ÕÒ²»µ½»òÕßÎÒÃÇÒѾ­Ô½¹ýÁËÓαêµÄ·¶Î§¡££­£­Èç²éѯ²»µ½Ïà¹ØÐÅÏ¢µÈ
¿ÉÄÜ·¢ÉúµÄ´íÎóÁÐ±í£º
-12, Out of memory in line %d.
ͨ³£²»³öÏÖÕâ¸ö´íÎó¡£ÕâÊÇÄãµÄÐéÄâÄÚ´æºÄ¾¡µÄ±êÖ¾¡£
-200, Unsupported type %s on line %d.
ͨ³£²»³öÏÖÕâ¸ö´íÎó£®Õâ±íÃ÷Ô¤±àÒëÆ÷Éú³ÉÁËһЩ¿â£¨º¯Êý£©²»ÈϵõĶ«Î÷£®¿ÉÄÜÄãÔËÐеÄÔ¤±àÒëÆ÷ºÍµ±Ç°¿â²»¼æÈÝ£®
-201, Too many arguments line %d.
ÕâÒâζ×Å Postgres ·µ»ØÁ˱ÈÎÒÃÇµÄÆ¥Åä±äÁ¿¸ü¶àµÄ²ÎÊý£®¿ÉÄÜÄã©Á˼¸¸öINTO :var1,:var2-ÁбíÀïµÄËÞÖ÷±äÁ¿£®
-202, Too few arguments line %d.
ÕâÒâζ×Å Postgres ·µ»ØÁ˱ÈÎÒÃǵĶÔÓ¦ËÞÖ÷±äÁ¿ÒªÉٵIJÎÊý£®¿ÉÄÜÄã¶àÊäÈëÁ˼¸¸öINTO :var1,:var2-ÁбíÀïµÄËÞÖ÷±äÁ¿£®
-203, Too many matches line %d.
×ÅÒâζ×Ųéѯ·µ»ØÁ˶à¸öÐУ¬µ«ÄãÉùÃ÷µÄ±äÁ¿²»ÊÇÊý×飮ÄãÖ´ÐÐµÄ SELECT ¿ÉÄܲ»ÊÇΨһµÄ£®
-204, Not correctly formatted int type: %s line %d.
×ÅÒâζ×ÅËÞÖ÷±äÁ¿ÊÇÒ»¸ö int ÀàÐͲ¢ÇÒ Postgres Êý¾Ý¿âÀïµÄ×Ö¶ÎÊÇÁíÒ»ÖÖÀàÐÍ£¬°üº¬×ÅÒ»¸ö²»ÄÜת»»³ÉÒ»¸ö int ÀàÐ͵ÄÊýÖµ£®¿â£¨º¯Êý£©Ê¹Óà strtol ×ö´ËÀàת»»£®
-205, Not correctly formatted unsigned type: %s line %d.
×ÅÒâζ×ÅËÞÖ÷±äÁ¿ÊÇÒ»¸ö unsigned int£¨ÎÞ·ûºÅÕûÊý£©ÀàÐͶøPostgres Êý¾Ý¿âÀïµÄ×Ö¶ÎÊÇÁíÍâÒ»ÖÖÀàÐͲ¢ÇÒ°üº¬Ò»¸ö²»ÄÜת»»³Éunsigned int µÄÊýÖµ£®¿â£¨º¯Êý£©Ê¹Óà strtoul ×öÕâÀàת»»£®
-206, Not correctly formatted floating point type: %s line %d.
×ÅÒâζ×ÅËÞÖ÷±äÁ¿ÊÇÒ»¸ö float £¨¸¡µã£©ÀàÐͶø Postgres Êý¾Ý¿âÀïµÄ×Ö¶ÎÊÇÁíÍâÒ»ÖÖÀàÐͲ¢ÇÒ°üº¬Ò»¸ö²»ÄÜת»»³É float µÄÊýÖµ£®¿â£¨º¯Êý£©Ê¹Óà strtod ×öÕâÀàת»»£®
-207, Unable to convert %s to bool on line %d.
ÕâÒâζ×ÅËÞÖ÷±äÁ¿ÊÇÒ»¸ö bool £¨²¼¶û£©ÀàÐÍ£¬¶ø Postgres Êý¾Ý¿âÀïµÄ×Ö¶ÎÖµ¼È²»ÊÇ 't' Ò²²»ÊÇ 'f'¡£
-208, Empty query l


Ïà¹ØÎĵµ£º

SQL Server 2000 Êý¾Ý¿âͬ²½

SQL Server 2000 Êý¾Ý¿âͬ²½ÅäÖõÄÔ­Àí
¸´ÖƵĸÅÄî
Microsoft? SQL Server? 2000 µÄ¸´ÖÆÊÇÔÚÊý¾Ý¿âÖ®¼ä¶ÔÊý¾ÝºÍÊý¾Ý¿â¶ÔÏó½øÐи´ÖÆ
ºÍ·Ö·¢²¢½øÐÐͬ²½ÒÔÈ·±£ÆäÒ»ÖÂÐÔµÄÒ»×é¼¼Êõ¡£
ʹÓø´ÖÆ¿ÉÒÔ½«Êý¾Ý·Ö·¢µ½²»Í¬Î»Öã¬Í¨¹ý¾ÖÓòÍø¡¢Ê¹Óò¦ºÅÁ¬½Ó¡¢Í¨¹ý Internet ·Ö
·¢¸øÔ¶³Ì»òÒÆ¶¯Óû§¡£¸´ÖÆ»¹Äܹ»Ê¹Óû§Ìá¸ßÓ¦ÓóÌÐòÐÔÄÜ ......

sql È¡·´

 update anketo1 set fb = substring('10',fb+1,1) WHERE id =5
ºóÀ´ÎÊÁËBM,BM˵ֱ½ÓÈ¡·´
update anketo1 set fb = ~ fb WHERE id =5
ÎÒ¸æËßÁËBMÓÃsubstringÒ²¿ÉÒÔ.
BM˵:"Õâ¼Ò»ïÀ÷º¦£¬ÕâÒ²ÄÜÏë³ö,ÕâÊôÓÚаÃÅÎ书."
×îºóÓÖÏëµ½ÓÃABSÈ¡¾ø¶ÔÖµÒ²¿ÉÒÔ
update anketo1 set fb = abs(fb-1)
ÎÒ¾õµÃ²»¹ÜÊÇʲôÎ书,ÄÜÖ ......

ÅäÖÃʹÓà SQL ServerÌṩ³ÌÐò ¡£

 ÅäÖÃʹÓà SQL ServerÌṩ³ÌÐò
 <configuration>
  <system.web> <-- ¸ü¸ÄÌṩ³ÌÐòÅäÖ㺠-->
    <membership defaultProvider="AspNetSqlProvider" />
  </system.web>
  <membership> <--ÅäÖÃÌṩ³ÌÐò -->
  <prov ......

ѧϰoracle sql loader µÄʹÓÃ

Ò»£ºsql loader µÄÌØµã
oracle×Ô¼º´øÁ˺ܶàµÄ¹¤¾ß¿ÉÒÔÓÃÀ´½øÐÐÊý¾ÝµÄÇ¨ÒÆ¡¢±¸·ÝºÍ»Ö¸´µÈ¹¤×÷¡£µ«ÊÇÿ¸ö¹¤¾ß¶¼ÓÐ×Ô¼ºµÄÌØµã¡£
 ±ÈÈç˵expºÍimp¿ÉÒÔ¶ÔÊý¾Ý¿âÖеÄÊý¾Ý½øÐе¼³öºÍµ¼³öµÄ¹¤×÷£¬ÊÇÒ»ÖֺܺõÄÊý¾Ý¿â±¸·ÝºÍ»Ö¸´µÄ¹¤¾ß£¬Òò´ËÖ÷ÒªÓÃÔÚÊý¾Ý¿âµÄÈȱ¸·ÝºÍ»Ö¸´·½Ãæ¡£ÓÐ×ÅËٶȿ죬ʹÓüòµ¥£¬¿ì½ÝµÄÓŵ㣻ͬʱҲÓÐһР......

SQL SERVER 2005 °²×°´íÎó½â¾öÁË~

½ñÌìÔÚһ̨Ðé»úÉϰ²×° sql server 2005£¬¾ÓÈ»±¨1´íÁË£¨ÎÞÓïÁË£¬×°Õâ¸ö¶«Î÷¶¼Åª²»ºÃ%>_<%£©¿ªÊ¼ÒÔΪÊÇÒòΪADÓòµÄÔ­Òò£¬ºóÀ´É¾µôÓòÓÖÖØ½¨Óò£¬È»ºóÔÙ×°£¬ÓÖ±¨2´í£¬ÓÚÊÇÎʱðÈËËÑË÷µÈµÈ£¬ÕÒµ½Ô­ÒòËµÒªÖØÐÂ×¢²áinstaller£¬×îÖÕ°²×°³É¹¦ÁË£¬º¦ÎÒ¼Ó°à۵쬏ßÐ˵ÄÊǰ²×°ºÃÀ²£¬¿ÉÊÇÎÒûÓÐŪÃ÷°×µ½µ×ÊÇɶԭÒòµ¼ÖÂsql°²×°²»ÁËÄØ£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ