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

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


Ïà¹ØÎÊ´ð£º

sql server ´æ´¢¹ý³ÌÑ­»·¸³ÖµµÄÎÊÌâ

СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
    @p001 nvarchar(8000),
    @p002 nvarchar(8000),
    @p003 nvarchar(8000),
  & ......

sql ÎÊÌâ

DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)

string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime ......

SQL ¶à±í²éѯ²é³öËùÒªµÄÊý¾Ý£¿

ÒÑÖª´ÓB,±íÖÐÕÒ³öID, NAMEÁ½ÏîÓëC±íÏàͬµÄÊý¾Ý£¬ÔÙÒÀ¾ÝB±íÖо­¹ý²éѯ³öÀ´µÄID,CODEÁ½ÏîÊý¾Ý²éѯÓëA±íID,CODEÁ½ÏîÏàͬµÄÊý¾ÝÖжÔÓ¦µÄEMAILÀ´£¬²¢ÁгöÈçÏÂD±íµÄÐÎʽ£¬²»ÖªÎÒÊÇ·ñ±íʾÇå³þ£¿Âé·³°ïÎÒÁÐһϹ«Ê½ºÃÂð£¿Íò· ......

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

ÇóÒ»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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ