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

sql²éѯÎÊÌâ

select id from dcr_hao where haono='1000000000547001 198953273313'
ÕâÑùµÄ  Ôõô²éѯ²»µ½£¿
Êý¾Ý¿âÀïÓÐÕâÌõ¼Ç¼°¡  ÊDz»ÊÇÓпոñµÄÔ­Òò ?
Äã¿´¿´haono×Ö¶ÎÀïÊDz»ÊÇǰºóÓпոñ°¡£¬ÔÚÊý¾Ý¿âÀïÒ²¼ì²éһϡ£

ûÓпոñ..

SQL code:

select id from dcr_hao where haono='1000000000547001 198953273313'
--²é²»µ½Êý¾ÝÊÇÒòΪÄãµÄhaono×Ö¶ÎûÓеÈÓÚ1000000000547001 198953273313µÄÖµºÍ¿Õ¸ñû¹ØÏµµÄ



×Ö¶ÎÓпոñÊÇ¿ÉÒÔ²éѯ³öÀ´µÄ¡£

desc dcr_hao ;

¿´Ò»ÏÂÄãµÄ±í½á¹¹¡£

Èç¹ûÈ·¶¨ÄãµÄ haono ÊÇ×Ö·ûÐÍ£¬Ôò

select id , haono from dcr_hao where haono like '1000000000547001%';

Ìù³öÀ´¿´Ò»Ï¡£¹À¼ÆÊǸù±¾Ã»ÓзûºÏÌõ¼þµÄ¼Ç¼¡£

¹À¼ÆÊÇûÓÐÕâ¸öÖµ»òÕßÀàÐͳö´í

PHP code:
select id from dcr_hao where haono='1000000000547001 198953273313'

where Ìõ¼þºóÃæµÄ`haono`Õâ¸ö×Ö¶ÎÄãûÓÐselect ³öÀ´
Õâôд£º
PHP code:
select id, [color=#FF0000]haono[/color] from dcr_hao where [color=#FF0000]haono[/color]='1000000000547001 198953273313'



PHP code



Code highlighting produced by Actipro CodeHighli


Ïà¹ØÎÊ´ð£º

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

±íÈçÏÂ
½ÌÊÒID ×ùλÊý ¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä 2009Äê1ÔÂ1ÈÕ 2009Äê1ÔÂ2ÈÕ 2009Äê1ÔÂ3ÈÕ
  101 50 08£º00 08£º30 30 40 50  
  101 50 09£º00 ......

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

¾ÈÃü°¡£¡£¡JSPÁ¬½ÓSQL2000ÎÊÌ⣡

¸÷λ´óÏÀ¾ÈÃü°¡ £¡£¡
¸Õ×°ÁËSQL2000 sp3
ÏëÓÃJSPÁ¬½ÓÊý¾Ý¿âµ«ÊdzöÏÖÎÊÌâÁË
ÎÒÓõÄÊÇJDK6.0+tomcat5.0+SQL2000 SP3+JDBC sp3
ËüÏÔʾµÄÊÇ
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver fo ......

Asp+sql serverÎÊÌâ - Web ¿ª·¢ / ASP

ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º ......

sql º¯ÊýÎÊÌâ

sql 2005Êý¾Ý¿âÎÒÏëµÃµ½Ò»×Ö·û´®Îª:
sldkf|||sdeww
erkv|||rltdk
jemcl|||ligf
¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð»
ÔΠ µ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ