SQL ²ð·Ö×Ö·û´®
ÓÐtb±í id tags 1 1,2,3 2 1,2 3 1,5,10 4 2,6 5 4,9,15 6 5,8 Èç¹ûÒª¸ù¾Ýtags È¡ÄÚÈÝÏàËÆ¶È×î¸ßµÄǰ5ÌõÊý¾Ý,Ôõôд? ±ÈÈçÎÒµÄÒ»ÌõÊý¾ÝµÄtagsÊÇ'4,9,15' ÄÇÊ×ÏȲéѯ³öÉÏÊöÊý¾ÝÖÐtags='4,9,15' È»ºó²éѯtags°üº¬'4,9'»òÕß'4,15'»òÕß'9,15' ×îºó²éѯ°üº¬'4' »ò '9' »ò '15' µÄ tags×î¶àÓÐ5¸öÊý×Ö×é³É.
×ö¸ö¼ÇºÅ¡£µÈµÈ»ØÀ´¿´ ¡£ ¶î ¸Ð¾õºÃ¸´ÔÓ°¡ ¿ÉÒÔsplit(',') ·Åµ½Ò»¸öÊý×éÖÐ È»ºóÑ»·¶Ô±È ȷʵͦ¸´Ô ¹Ø×¢Ò»Ï »»´æ´¢½á¹¹°É. Òª²»ÄãµÃÏȰÑtb±íÖÐÿÌõÊý¾Ý¸øsplitÁËÔٰѲéѯÊý¾Ýsplit,ÔÙ½øÐи´ÔÓµÄËã·¨²Å¿ÉÒÔ.·Ç³£·±ËöºÍÀË·Ñ×ÊÔ´. Ä㻹²»Èç´æ³É id tags 1 1 1 2 1 3 2 1 2 2 ÕâÑù.ÕâÑùµÄ»°,Ò»¾äsqlÓï¾ä¾ÍÄܸ㶨. select top 5 count(id) as countId where tags in (4,9,15) group by id order by countId ºÃ¾Ã²»Ð´sqlÁË.ûÓÐʵ¼Ê²âÊÔ.˼·ÊÇÕâÑù.Äã×Ô¼º¸Ä¸Ä°É.ÒýÓà »»´æ´¢½á¹¹°É. Òª²»ÄãµÃÏȰÑtb±íÖÐÿÌõÊý¾Ý¸øsplitÁËÔٰѲéѯÊý¾Ýsp
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º 1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã© Ñ¡ÔñºÃÎļþºó µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏ 2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql 3 ......
ÎÒÊý¾Ý¿âÊÇMSSQLµÄ£¬×òÌìËùÓÐµÄ±í±»×¢ÈëJS½Å±¾´úÂë,Óиö²»Ã÷°×µÄµØ·½À´ÎÊÎÊ´ó¼Ò ÎÒ·¢ÏÖÓÐЩ±íÎÒ¸ù±¾Ã»Ê¹Óã¬Ò²Ã»ÓÐÈë¿âµÄASPÒ³ÃæºÍÓï¾ä£¬ËüÊÇÔÛ¸ö×¢ÈëµÄÄØ£¿ Ã²ËÆselectÓï¾äÊÇ¿ÉÒÔǶÌ׵İɣ¿ ¿ÉÄÜÊÇwhere ......
ÒÑÖª´ÓB,±íÖÐÕÒ³öID, NAMEÁ½ÏîÓëC±íÏàͬµÄÊý¾Ý£¬ÔÙÒÀ¾ÝB±íÖо¹ý²éѯ³öÀ´µÄID,CODEÁ½ÏîÊý¾Ý²éѯÓëA±íID,CODEÁ½ÏîÏàͬµÄÊý¾ÝÖжÔÓ¦µÄEMAILÀ´£¬²¢ÁгöÈçÏÂD±íµÄÐÎʽ£¬²»ÖªÎÒÊÇ·ñ±íʾÇå³þ£¿Âé·³°ïÎÒÁÐһϹ«Ê½ºÃÂð£¿Íò· ......
ÔÚsqlÖÐʹÓÃoutputºÍ²»Ê¹ÓõÄÇø±ð£¿ ÀýÈ磺 ALTER PROCEDURE [dbo].[sp_1] @SYS_LNNO varchar(20), @SYS_CALLER varchar(20), @SYS_ORGANIZE varchar(10), ......
СµÜÕý×¼±¸×Ô¼ºÌáǰѧϰÊý¾Ý¿â£¬µ«ÊÇÏÖÔÚÓиöÎÊÌ⣬²»ÖªµÀ¸ÃÑ¡Ôñʲô°æ±¾µÄSQL ѧУÒÔºóµÄÊéºÃÏñ½²SQLÓõÄÊÇSQL 2000£¬µ«ÊÇÎÒµÄϵͳÊÇWindows 7£¬Ã²ËƲ»ÄÜ×°£¬Ò²²»Ïë»»»ØXP£¨07Äê¾Í²»ÓÃXPÀ²£©£¬ËùÒÔÔÚÏ룬ÄÜ· ......