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

¿ÉÒÔÕâÑùдSQLÂ𣿠- .NET¼¼Êõ / ASP.NET

select id,pid,d_name,case when del_sign=0 then '»î¶¯' else 'ÒÑɾ³ý' as del_sign from dept_name order by pid

ÎÒÏë°ó¶¨DataGrid£¬ÅжÏÊÇ·ñɾ³ýÀ¸ÏëÏÔʾ ¡°»î¶¯¡±»ò¡°ÒÑɾ³ý¡±£¨¼´¸ù¾Ý0£¬1À´¾ö¶¨£©

ÌáʾÓï·¨Óдí....

ÉÙÁËÒ»¸öEND£¬
case when end

¶ÔÍ·¡£¶¥Â¥ÉϵÄͼ

caseȱÉÙ end

ßÀ£¬ÉÙ¸öend¡£¡£¡£´óÒâÁË

Áí£ºÎÒÏë¸ù¾ÝpidÏÔʾ³öd_name£¬ÒªÔõÃ´Ð´ÄØ£¿ÔÙÌײãselect?

ÒýÓÃ
SQL code

select id,pid,d_name,case del_sign when 0 then '»î¶¯' else 'ÒÑɾ³ý' end as del_sign from dept_name order by pid



up

Îҵıí½á¹¹ÊÇÎÞÏÞ¼¶·ÖÀàµÄ£¬ÎÒÏëÔÚÏÔʾijһid¶ÔÓ¦µÄÖÐÎÄÃû×Ö(d_name)µÄʱºòÒ²ÏÔʾÆä¸¸id(¼´pid)¶ÔÓ¦µÄÖÐÎÄÃû×Ö(d_name)



ÒýÓÃ
ßÀ£¬ÉÙ¸öend¡£¡£¡£´óÒâÁË

Áí£ºÎÒÏë¸ù¾ÝpidÏÔʾ³öd_name£¬ÒªÔõÃ´Ð´ÄØ£¿ÔÙÌײãselect?


ʾÀý:
SELECT ProductNumber, Name, 'Price Range' = 
  CASE 
  WHEN ListPrice = 0 THEN 'Mfg item - not for resale'
  WHEN ListPrice < 50 THEN 'Under $50'
  WHEN ListPrice >= 50 and ListPrice < 250 THEN 'Under $250'
  WHEN ListPrice >= 250 and ListPrice < 1000 THEN 'Under $1000'
  ELSE 'Over $1000'
  END
from Production.Product
ORDER BY ProductNumber ;


SQL code



Code highlighting


Ïà¹ØÎÊ´ð£º

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

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

ÇóÖú£ºÕÒASP.NETÍøÒ³ÖÆ×÷¸ßÊÖ£¬Óб¨³ê¡£

±¾ÈËÊDzËÄñÒ»¸ö£¬Æ½Ê±Òª×öÉúÒ⣬µ«ÊÇÕÒÁ˺ܶàÈË×öÍøÕ¾£¬¾ù±»Æ­ÁË¡£×öµÃ²»Èý²»ËÄ£¬ÏÖÔÚ¾öÐÄ×Ô¼ºÀ´×öÒ»¸ö£¬ÒÑѧϰASP.NETÏà¹ØµÄÍøÒ³ÖÆ×÷֪ʶ£¬ÓÐDW»ù´¡£¬¿ÉÒÔ˵ÊÇĿǰֻÓÐÀíÂÛ֪ʶ£¬µ«ÊÇÔÚʵ¼Ê¾ßÌå²Ù×÷µÄʱºò£¬×ÜÊÇÓöµ ......

wapÍøÕ¾¿ª·¢µÄÎÊÌâ - .NET¼¼Êõ / ASP.NET

ÎÒÓÃ.net¿ª·¢wapÍøÕ¾
1£¬ÎÒ´Ó¹¤¾ßÏäÀïÍÏÁËÁ½¸ölink£¬ÕâÁ½¸ölink»áÏÔʾÔÚÁ½ÐУ¬Èç¹ûÈÃÕâÁ½¸ölink´¦ÓÚͬһÐС£
2£¬ÈçºÎÏÔʾÁ½¸ö¿Ø¼þÖ®¼äµÄ¿Õ¸ñÎÊÌâ¡£
¸úwapÓйØÂ𣿲»Ì«Ã÷°×

ÓÑÇé°ï¶¥¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£

¾Í ......

asp.net ÏÂÔØ - .NET¼¼Êõ / ASP.NET

sqlserverµÄÊý¾Ý¿â£¬×Ö¶ÎÊÇimageÀàÐ͵ġ£Ôõôд´úÂ룬ÔÚÒ³ÃæÖеã»÷¡°ÏÂÔØ¡±¾ÍÄÜ´ò¿ªÄǸöÏÂÔØ¶Ô»°¿ò£¿
PS£ºOracleLob ÔÚsqlserverÀïÊÇʲô£¿
Response.Redirect("test.jpg")

ÒýÓÃ
Response.Redirect( ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ