Çë½ÌÊÖ»úÌôºÅSql²éѯÓï¾äд·¨
×î½üÔÚ×öÒ»¸ö³öÊÛºÅÂëµÄÍøÕ¾£¬¿Í»§ÓÐÕâÑùÒ»¸öËÑË÷ÐèÇ󣬰´ºÅÂë¹æÔò£¨AABB¡¢ABCDABCD¡¢AB*AB* ¡¡£©ËÑË÷ºÅÂë¡£ È磺 1¡¢Óû§°´¹æÔò¡°AABB¡±ËÑË÷£¬Ôò½«ÒÔϽá¹ûÏÔʾ³öÀ´£º 13011223456 13012445568 13012348899 ¡¡ 2¡¢Óû§°´¹æÔò¡°ABCDABCD¡±ËÑË÷£¬Ôò½«ÒÔϽá¹ûÏÔʾ³öÀ´£º 13812341234 13875317531 ¡¡ 2¡¢Óû§°´¹æÔò¡°AB*AB*¡±ËÑË÷£¬Ôò½«ÒÔϽá¹ûÏÔʾ³öÀ´£º 18912512345 18900754759 ¡¡ ÏÖʹÓõķ½·¨£¬ÊÇÔÚ³ÌÐòÀïÆ´´Õ¹æÔò²éѯÓï¾ä,µ«Ð§ÂÊÊ®·ÖµÍ¡£Èç¹æÔòΪ¡°AABB¡±ÔòÉú³ÉSqlÓï¾äΪ£º ¡¡ AND ([No] LIKE '%0011%' OR [No] LIKE '%0022%' ¡¡ OR [No] LIKE '%9988%') ²î²»¶à100¸öORÓï¾ä Çë½Ì¸÷λ¸ßÊÖÓÐʲô¸üºÃµÄ½â¾ö·½°¸£¬Íû´Í½Ì£¬Ð»Ð»´ó¼Ò
ÄǸöAB*AB*ÊÇʲôÒâ˼£¿ ? Ñ»·½ØÈ¡ ÎÒµÈ~ Õâ¸öÃ²ËÆSQL×ö²»ÁË,µÃÓÃÕýÔò±í´ïʽ×ö. °ï¶¥! * ÊÇ´ú±íÈÎÒâµ¥¸öÊý×Ö SqlServer²»ÄÜÖ±½ÓÖ§³ÖÕýÔò±í´ïʽ°¡ÒýÓà SqlServer²»ÄÜÖ±½ÓÖ§³ÖÕýÔò±í´ïʽ°¡ CLR? Çë½Ì3Â¥£¬ÈçºÎ"Ñ»·½ØÈ¡"£¿ ֮ǰҲÏë¹ý£¬Òò¹æÔò±È½Ï¸´ÔÓ£¬¸Ð¾õ²»Ì«ºÃ×ö£¬Çë´Í½ÌÓкθüºÃµÄ·½·¨ ¹Ø×¢¡£¿´µ½ºÃ¶àÊÛºÅÍø¶¼ÓÐÕâÖÖËÑË÷£¬¿´¿´ÊÇÔõô×ö³öÀ´µÄ¡£ ²Â²»³öÄãµÄÕâ¸öºÅÂë×Ö¶ÎÊÇÊý×ÖÐÍ»¹ÊÇ×Ö·ûÐÍ¡£ Êý×ÖÐͺÍ×Ö·ûÐÍʵÏÖÉÏÂÔÓвî±ð¡£ (²»Òª¸ß¹ÀÄãµÄººÓï±í´ïÄÜÁ¦»òÕßÎҵĺºÓïÀí½âÄÜÁ¦) ½¨ÒéÄãÁгöÄãµÄ±í½á¹¹£¬²¢Ìṩ²âÊÔÊý¾
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º 1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã© Ñ¡ÔñºÃÎļþºó µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏ 2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql 3 ......
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
protected void btnLogin_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login"); &nb ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......