¿ÉÒÔÕâÑùд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
Ïà¹ØÎÊ´ð£º
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼: Àý£º
......
±¾ÈËÊDzËÄñÒ»¸ö£¬Æ½Ê±Òª×öÉúÒ⣬µ«ÊÇÕÒÁ˺ܶàÈË×öÍøÕ¾£¬¾ù±»ÆÁË¡£×öµÃ²»Èý²»ËÄ£¬ÏÖÔÚ¾öÐÄ×Ô¼ºÀ´×öÒ»¸ö£¬ÒÑѧϰASP.NETÏà¹ØµÄÍøÒ³ÖÆ×÷֪ʶ£¬ÓÐDW»ù´¡£¬¿ÉÒÔ˵ÊÇĿǰֻÓÐÀíÂÛ֪ʶ£¬µ«ÊÇÔÚʵ¼Ê¾ßÌå²Ù×÷µÄʱºò£¬×ÜÊÇÓöµ ......
ÎÒÓÃ.net¿ª·¢wapÍøÕ¾ 1£¬ÎÒ´Ó¹¤¾ßÏäÀïÍÏÁËÁ½¸ölink£¬ÕâÁ½¸ölink»áÏÔʾÔÚÁ½ÐУ¬Èç¹ûÈÃÕâÁ½¸ölink´¦ÓÚͬһÐС£ 2£¬ÈçºÎÏÔʾÁ½¸ö¿Ø¼þÖ®¼äµÄ¿Õ¸ñÎÊÌâ¡£ ¸úwapÓйØÂ𣿲»Ì«Ã÷°× ÓÑÇé°ï¶¥¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£ ¾Í ......
sqlserverµÄÊý¾Ý¿â£¬×Ö¶ÎÊÇimageÀàÐ͵ġ£Ôõôд´úÂ룬ÔÚÒ³ÃæÖеã»÷¡°ÏÂÔØ¡±¾ÍÄÜ´ò¿ªÄǸöÏÂÔØ¶Ô»°¿ò£¿ PS£ºOracleLob ÔÚsqlserverÀïÊÇʲô£¿ Response.Redirect("test.jpg") ÒýÓà Response.Redirect( ......