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

sqlÎÊÌâ¡¡¸ß·Ö - ÆäËûÊý¾Ý¿â¿ª·¢ / Sybase

ÔÚsybaseÖÐÔõôµÃµ½ÕâÑùµÄ½á¹û

Óбítb, ÈçÏ£º
id value
----- ------
1 aa
1 bb
2 aaa
2 bbb
2 ccc
ÐèÒªµÃµ½½á¹û£º
id values
------ -----------
1 aa,bb
2 aaa,bbb,ccc


ÊÇASE»¹ÊÇASA£¿ASAÓÃLIST£¬Ç°ÕßÓñäÁ¿Àۼӵķ½·¨

ÒýÓÃ
ÊÇASE»¹ÊÇASA£¿ASAÓÃLIST£¬Ç°ÕßÓñäÁ¿Àۼӵķ½·¨


ASE, Äܸø¸öÀý×ÓÂð£¿sybase²»Ö§³Ö×Ô¶¨Ò庯ÊýÂð£¿


ʾÀý£¬×ÔÐÐÐÞ¸Ä
declare @ee varchar(500);
declare @ee1 varchar(500);
declare @num int;
set @ee='';
set @ee1='';
set @num=1;
select *,space(500) as gd,0000 as gdnum into #tt from blljtest;
  update #tt set gd=(case when @ee1=class then @ee || ',' || name else name end) ,
@ee=(case when @ee1=class then @ee || ',' || name else name end),
gdnum=(case when @ee1=class then @num+1 else 1 end),
@num=(case when @ee1=class then @num+1 else 1 end),@ee1=class;
select a.* from #tt a inner join 
(select class,max(gdnum) as ma from #tt group by class) b 
on a.class=b.class and a.gdnum=ma;


ÒýÓÃ
sybase²»ÖªµÀ.Ìṩ¸ösql serverµÄ.

SQL code
/*
±êÌ⣺°´Ä³×ֶκϲ¢×Ö·û´®Ö®Ò»(¼òµ¥ºÏ²¢)
×÷Õߣº°®Ð¾õÂÞ.ع»ª(Ê®°ËÄê·çÓê,ÊØµÃ±ùɽѩÁ«»¨¿ª)
ʱ¼ä£º2008-11-06
µØµã£º¹ã¶«ÉîÛÚ

ÃèÊö£º½«ÈçÏÂÐÎʽµÄÊý¾Ý°´id×ֶκϲ¢value×ֶΡ£
id


Ïà¹ØÎÊ´ð£º

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

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

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

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

ÇóÒ»sqlÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......

Çë½ÌSQLSERVERµÄÁ½¸öÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£
2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ )
ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......

ÇóÒ»ÌõSQLÓï¾ä - MS-SQL Server / Ó¦ÓÃʵÀý

Ô­SQLÓï¾äSQL code:

SELECT t6.FName '²Ù×÷¹¤',t1.FDate 'ÈÕÆÚ',t5.FName 'ÖÆµ¥ÈË',t3.FName 'É豸',t4.FName '°àÖÆ',
t7.FBillNo '¹¤ÒÕÖ¸Áîµ¥ºÅ',t8.FName '¸Úλ',t2. ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ