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

SQLÓï¾äÔõôд£¿

ÎÒÓÐÒ»Õűí Create table abc (ID int primary key, A varchar(20), B varchar(20)); Êý¾Ý¿âÖÐAºÍB×ֶβ»ÄÜÖØ¸´£¬Ò²¾ÍÊDZÈÈçÎÒ²åÈëÒ»Ìõ¼Ç¼ £ºinsert into abc(ID, A, B) values(1, abc123, abc456);
ÎÒÔÚ²åÈëµÚ¶þÌõ¼Ç¼µÄʱºò£¬¾Í²»ÄܲåÈë X>=abc123,»òÕßX <=abc456µÄÊý£¬Ò²¾ÍÊÇÖ´ÐÐÕâÑùÒ»ÌõдÈëÓï¾ä¾ÍÐèÒª±¨Ð´ÈëÖØ¸´µÄ´íÎó£ºinsert into abc(ID, A, B) values(1, abc124, abc455); Ò²¾ÍÊÇAºÍBÖ®¼äµÄÊý¶¼ËãÖØ¸´£¬Ò»Ìõ¼Ç¼¿ÉÒÔдÕâÑùÒ»ÌõsqlÓï¾ä½øÐÐÅжϣºselect * from abc where A>=abc123 and A <=abc456 and B>=abc123 abd B <=abc456 ²»ÄÜдÈ룬µ«ÊÇÊý¾Ý¿âÖÐÓÐ10ÍòÌõ¼Ç¼£¬ÕâÑù½øÐÐÖØ¸´ÅжϾÍÏԵúÜÂýÁË£¬Çë´ó¼Ò°ïæÏëÒ»¸ö±È½Ï¿ìËÙµÄÅжÏдÈëÊÇ·ñÖØ¸´µÄsqlÓï¾ä£¬Ð»Ð»£¡
abc122 abc467ËãÖØ¸´Âð

²»Ëã.

ÕâÑù¡£¡£¡£ÄDz»ÊDzåÈ뷶ΧֻÄÜÔ½À´Ô½Ð¡£¿

abc122 abc455ËãÖØ¸´Âð

ÒýÓÃ
ÕâÑù¡£¡£¡£ÄDz»ÊDzåÈ뷶ΧֻÄÜÔ½À´Ô½Ð¡£¿

ÕâÑùËãÖØ¸´

¾ÍÊÇÖ»Äܲå´óµÄ£¬²»ÄܲåСµÄ£¿Êǰɣ¿

ÒýÓÃ
abc122 abc455ËãÖØ¸´Âð

ÕâÑùÒ²ËãÖØ¸´.

»¹ÊǵÃÇëСPÁº.

ÄǾÍÊDzåÈëµÄʱºòAҪСÓÚÊý¾Ý¿âÖÐ×îСµÄA£¬BÒª´óÓÚÊý¾Ý¿âÖÐ×î´óµÄB£¿£¿

AºÍBÖ®¼äµÄÊýÊÇÁ¬ÐøµÄ,BÊÇÔÚAµÄ»ù´¡ÉϵÃÀ´µÄ.

ÒýÓÃ
ÄǾÍÊDzåÈëµÄʱºòAҪСÓÚÊý¾Ý¿âÖÐ×îСµÄA£¬BÒª´óÓÚÊý¾Ý¿âÖÐ×î´óµÄB£¿£¿

²»ÊÇ,ÒòΪдÈëµÚ¶þÌõ¼Ç¼²»Ò»¶¨Òª´ÓÊý¾Ý¿âÖÐ×î´óµÄ¿ªÊ¼Á¬Ðø.

û¿´¶®£¬¶àÁм¸ÌõÊý¾Ý

SQL code



Code highlighting produced by Actip


Ïà¹ØÎÊ´ð£º

sql ʱ¼äÎÊÌâ

sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001

ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......

SQL serverÊý¾Ý¼¯³ö´íÇóÖú

Á½ÖÖ´íÎó£º
1.Èç¹ûÎÒÕâÑùÉêÃ÷£ºResultSet rs;´íÎóÌáʾÈçÏ£º

An error occurred at line: 51 in the jsp file: /index.jsp
The local variable rs may not have been initialized
48:    ......

sql²éѯÒÉÎÊ

±íÖа´datadate,tradeidΪÖ÷¼ü£¬Ò²¾ÍÊÇ˵tradeid»áÖØ¸´³öÏÖÔÚ²»Í¬ÌìÖУ¬Í¬Ò»ÌìµÄtradeidÊDz»Í¬µÄ¡£ÏÖÔÚÎÒÏ£Íûȡһ¶Îʱ¼ä·¶Î§ÄÚ²»Öظ´µÄtradeid£¬ÇÒֻҪÿ¸ötradeidµÄ×îºóÒ»´Î³öÏÖµÄÄÇÌõ¡£sqlÓï¾ä¸ÃÔõôд

£º ......

sql server 2005ÔõôÉý¼¶£¿

ÒòΪѧϰµÄÐèÒª£¬ÓÃÁËÒ»¶Îʱ¼äµÄsql server 2005,ºÃÏñÊÇ˵sql server µÄÆÀ¹ÀÆÚÒѹý¡£ÏëÎÊһϴó¼ÒÎÒ¸ÃÔõÑùÉý¼¶°¡£¿
Íû´ó¼ÒÏêϸָµ¼Ò»Ï°¡£¬ÏÈлÁË¡­¡­
Éý¼¶Ê²Ã´???Ö±½ÓÏÂÔØ¸ö¿ª·¢°æ×°ÉϾÍOKÁË

Éý¼¶Ê²Ã´°¡£¬ ......

ÊÕ¼¯ÁËһЩ΢ÈísqlÏà¹ØÈÏÖ¤¿¼ÊÔµÄÊÔÌ⼯ºÏ£¬·ÖÏíÒ»ÏÂ

»ìSQL°æÕâô¾ÃÁË£¬·ÖÏíÒ»µã×ÊÁÏ

sql serverµÄÏà¹ØÈÏÖ¤µÄÊÔÌ⼯ºÏ£¬°æÓÑÓл¹ÔÚѧУµÄ»°¾ÍÏÂÔØÏÂÀ´Óлú»á¿¼ÊÔһϣ¬±Ï¾¹350Ôª´ó¼Ò»¹ÊǸºµ£µÃÆðµÄ£¬½«À´±ÏÒµºóÒ²ÊÇÒ»¸öºÃÒ»µãµÄÖ¤ÊéÖ¤Ã÷

Èç¹û×¼±¸×¨×¢ÓÚÕâ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ