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

Çë½ÌÊÖ»úÌôºÅ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Â¥£¬ÈçºÎ"Ñ­»·½ØÈ¡"£¿

֮ǰҲÏë¹ý£¬Òò¹æÔò±È½Ï¸´ÔÓ£¬¸Ð¾õ²»Ì«ºÃ×ö£¬Çë´Í½ÌÓкθüºÃµÄ·½·¨

¹Ø×¢¡£¿´µ½ºÃ¶àÊÛºÅÍø¶¼ÓÐÕâÖÖËÑË÷£¬¿´¿´ÊÇÔõô×ö³öÀ´µÄ¡£

²Â²»³öÄãµÄÕâ¸öºÅÂë×Ö¶ÎÊÇÊý×ÖÐÍ»¹ÊÇ×Ö·ûÐÍ¡£

Êý×ÖÐͺÍ×Ö·ûÐÍʵÏÖÉÏÂÔÓвî±ð¡£

(²»Òª¸ß¹ÀÄãµÄººÓï±í´ïÄÜÁ¦»òÕßÎҵĺºÓïÀí½âÄÜÁ¦)
  ½¨ÒéÄãÁгöÄãµÄ±í½á¹¹£¬²¢Ìṩ²âÊÔÊý¾


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

sqlССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......

ASPÁ´½ÓSQLµÄ¼òµ¥µÇ½½çÃæ - .NET¼¼Êõ / ASP.NET

protected void btnLogin_Click(object sender, EventArgs e)
  {
  SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ