¼òµ¥µÄsqlÎÊÌâ
ÐÕÃû ѧ¿Æ
a ÓïÎÄ
a Êýѧ
b Ó¢Óï
b ÕþÖÎ
ÎÒÏëµÃµ½ a ÓïÎÄ£¬Êýѧ
b Ó¢ÓÕþÖÎ
ÇëÎÊÔõôдsqlÓï¾ä
select * from table where 'ÐÕÃû'='a';
²»ÊÇÕâ¸ö ÎÒÕâÒªÏÔʾËùÓÐ ¶ø²»ÊǸù¾ÝÌõ¼þÀ´µÄ
ÐÐרÁеÄÎÊÌâ
http://blog.csdn.net/zhanyong168/archive/2009/01/08/3735969.aspx
²Î¿¼ÏÂÉÏÃæµÄ
ÏÔʾËùÓÐÊÇʲôÒâ˼°¡¡£select * from table¾ÍËùÓа¡¡£
ÐèÒªÓõ½ÐÐÁÐת»»ÁË¡£½¨Òé²Î¿¼²©¿Í£ºhttp://blog.csdn.net/chenjianyong94/archive/2009/05/06/4155420.aspx
¿´²»³ö¸ù¾Ýʲô¹æÂÉ
sql server °æ±¾ÇøÓÐÈËÎʹýÕâÑùµÄÎÊÌ⣬µ«ÊÇ´ð°¸Íü¼ÇÁË£¬ºÃÏñ²»ÊǺܸ´ÔÓ£¬ÄǸöÊÇÓÃ2005дµÄ
²éѯ³öÀ´°Ñ×Ö·û´®¼ÓÉÏ,
¶¥Ò»¸ö
лл´ó¼ÒµÄ»Ø´ð ²»¹ýÏ£ÍûÄܵõ½sql¶ø²»ÊÇÁ´½Ó
SQL code:
SELECT [ÐÕÃû],[ѧ¿Æ]=CAST([ѧ¿Æ] as nvarchar(100))
INTO #t from #test
ORDER BY [ÐÕÃû],[ѧ¿Æ]
DECLARE @col1 varchar,@col2 nvarchar(100)
UPDATE #t SET
@col2=CASE WHEN @col1=[ÐÕÃû] THEN @col2+','+[ѧ¿Æ] ELSE [ѧ¿Æ] END,
@col1=[ÐÕÃû],
[ѧ¿Æ]=@col2
SELECT [ÐÕÃû],[ѧ¿Æ]=MAX([ѧ¿Æ]) from #t GROUP BY [ÐÕÃû]
ÍüÁË˵ÁË£¬#test¾ÍÏ൱ÓÚÄãµÄ±í£¬Ã»Ð´½¨±íÓï¾ä
SQL c
Ïà¹ØÎÊ´ð£º
±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½Ãæȥѧϰ
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......
´íÎóÐÅÏ¢£º
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][Shared Memory]ÎÞЧµÄÁ¬½Ó¡£
/bbsxp/test.asp, µÚ 24 ÐÐ
»úÆ÷ÅäÖÃ:xp sp3 ,SQL 2005(vs ......
....½Óµ½Ò»¸öС³ÌÐò..¹¤×÷ÔÀ´´ó¸ÅÊÇÕâÑùµÄ...ǰ̨ÊÇWEB·þÎñÆ÷.¼Ü¹¹¾ÍÊÇASP+SQL..ǰ̨ÓÉASPÏòSQLÌí¼Ó·þÎñÀà±ð(±íµ¥).È»ºóÓÖºǫ́³ÌÐò¶ÁÈ¡±íµ¥..Ҫʵʱ¶ÁÈ¡..È»ºóÏÔʾÔÚ·þÎñÆ÷ÉÏÃæ..´ÓÀíÂÛÉÏÃæÄÜÐÐͨ²»?Èç¹û¿ÉÒÔ..ºǫ́ ......
sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001
ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......
@s='S1,S2,S12,S23';
½«@sÀïÃæµÄS1,S2Ìæ»»³É´¦Àí£¬Î´´¦Àí
À´ÕßÓзÖ.
REPLACE(@s,'S1,S2','´¦Àí,δ´¦Àí')
REPLACE ²»ºÃÓà ×Ô¼ºÊÔÏÂ
SQL code:
declare @s ......