sqlÓï¾äÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ
ÏÖÔÚÓÐÒ»¸ö²¿Ãűídept£¨²¿ÃÅÃû³Æ£¬²¿Ãźš£¡££©ÓÐÒ»¸öÈËÔ±±íemp£¨ÐÕÃû£¬ÈËÔ±±àºÅ£¬Ö°Î»£¬Ð½×Ê£¬²¿ÃÅ£©
emp±íÖеÄÄÚÈÝÊÇÕâÑùµÄ£º
a 1 ¹¤³Ìʦ 3000 Èí¼þ²¿
b 2 ÆÕͨԱ¹¤ 2000 Ó²¼þ²¿
c 3 ¹¤³Ìʦ 4000 Ó²¼þ²¿
d 4 ÆäËû 1500 °ì¹«ÊÒ
н×ÊÔö³¤¸ù¾ÝְλÀ´Ôö£¨¹¤³Ìʦн×ÊÔö³¤ÔÀ´µÄ1.2±¶£¬ÆÕͨԱ¹¤Ôö³¤ÎªÔÀ´µÄ1.1±¶£¬ÆäËûµÄÔö³¤ÎªÔÀ´µÄ1.05±¶£©
ÎÒÒª²é³ö¼ÓнǰºÍ¼ÓнºóµÄÈ˵ÄÐÅÏ¢£¨ÓÃsqlÓï¾ä±íʾ³öÀ´£¬ÎÒ¸ÃÔõÃ´Ð´ÄØ£¬Çë½Ì¸ßÊÖÁË£¬Ð»Ð»£¡£©
SQL code:
select ÐÕÃû,
ÈËÔ±±àºÅ,
ְλ,
н×Ê=(case when ְλ='¹¤³Ìʦ' then н×Ê*1.2
when ְλ='ÆÕͨԱ¹¤' then н×Ê*1.05 else н×Ê end),
н×Ê as [н×Ê(µ÷Õûǰ)]
from emp
SQL code:
select t.* , case ְλ when '¹¤³Ìʦ' then н×Ê * 1.2 when 'ÆÕͨԱ¹¤' н×Ê * 1.1 else н×Ê * 1.05 end ¼Óнºó from emp t
Ç¿°¡£¬¶¼ÄÜ¿´¶®
SQL code
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighl
Ïà¹ØÎÊ´ð£º
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
×Ö¶Î1,×Ö¶Î2.....×Ö¶ÎN,Status,ParentID
1,Name1....test1,1,99
1,Name1....test1,3,99
1,Name2....test2,1,101
1,Name2....test2,3,101
1,Name3....test3,2,101
1,Name1....test1,4,101
ÏëÒªµÄ½á¹ûÊÇ:
1,Na ......
ÏÂÃæÊÇXML³õʼÎļþÄÚÈÝ
XML code:
<upd:Update xmlns:lar="http://schemas.microsoft.com/msus/2002/12/LogicalApplicabilityRules" xmlns:cmd="http://schemas.microsoft.com/msus/2002/12/Up ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......