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

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
select ÐÕÃû,
ÈËÔ±±àºÅ,
ְλ,
н×Ê=(case when ְλ='¹¤³Ìʦ' then н×Ê*1.2
when ְλ='ÆÕͨԱ¹¤' then н×Ê*1.05 else н×Ê end),
н×Ê as [н×Ê(µ÷Õûǰ)]
from emp


SQL code



Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighl


Ïà¹ØÎÊ´ð£º

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



type Exception report


message

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

exception

org.apache.jas ......

Asp+sql serverÎÊÌâ - Web ¿ª·¢ / ASP

ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º ......

ÇóÒ»¸öSQLÓï¾ä - MS-SQL Server / »ù´¡Àà

×Ö¶Î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 ......

SQL server·Ö½âXML - MS-SQL Server / Ó¦ÓÃʵÀý

ÏÂÃæÊÇ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·ÖÒ³ÓëOracle·ÖÒ³µÄÒÉÎÊ£¿ - Java / Web ¿ª·¢

ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ