sql ×Ö·û´®´¦Àí - MS-SQL Server / Ó¦ÓÃʵÀý
ÓÐÒ»¸ö±íµÄ×Ö¶ÎFileName±£´æÊý¾ÝÊÇ:010101 »ò 100010 »ò 111100 111111 ´ú±í == >> abcdef create table a ( id int not null, FileName varchar(100) not null ) insert into a values(1,'010101') insert into a values(2,'100010 ') insert into a values(3,'111100') Æ©Èç:ÊäÈëÒ»¸ö FileNameµÄֵΪ 010101 --->>b;d;f Èç: select funs('010101') from a; /** b;d;f */ funsÕâ¸öº¯ÊýÒªÇó°ïæµÄ..лл
ÒªÇóдһ¸öº¯Êý ³¤¶ÈÊǹ̶¨µÄ²»£¿ SQL code: case when substing(FileName,1,1)=0 then '' else 'a' end +';'+ case when substing(FileName,2,1)=0 then '' else 'b' end +';'+ case when substing(FileName,3,1)=0 then '' else 'c' end +';'+ ......ÒýÓà SQL code case when substing(FileName,1,1)=0 then '' else 'a' end +';'+ case when substing(FileName,2,1)=0 then '' else 'b' end +';'+ case when substing(FileName,3,1)=0 then '' else 'c' end +';'+ ...¡¡ Õâ¸ö²»ÊÇÎÒÏëÒªµÄ.. ³¤¶È²»¹Ì¶¨µÄ.. ´Ó¡°010101¡± ת»»¡°b;d;f¡±£¬ËûÃǵĹØÏµÊÇʲô£¿Èç¹ûÒ»µã¹ØÏµ¶¼Ã»ÓУ¬ËüÊÇʲô³öÀ´µÄ£¬²»Ã÷°×£¿ ÊDz»ÊÇÕâ¸ö±í»¹ÓÐÆäËû×ֶΣ¿ ÊÇÓÐÆäËû±í... ÉÏÃæµÄÎÒÖ»ÊǾٸöÀý×Ó... SQL code Code highlighting produced by Actip
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º 1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã© Ñ¡ÔñºÃÎļþºó µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏ 2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql 3 ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£» ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£» ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿ ÖÁÉٵø½¼Óµ½sqlserverÉÏ ¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿ Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£ sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......
select o_customer,o_price from orders having o_price >=avg(o_price) select o_customer,o_price from orders where o_price >=(select avg(o_price) from orders) ÎҸоõûÓÐÇø±ð°¡£¬ÔõôÔÚmysql»áÓÐ ......
Ö´ÐÐÊý¾Ý¿â²Ù×÷ʱ£¬Ö±½ÓÓÃSQL Óï¾äºÃһЩ »¹ÊÇÓô洢¹ý³Ì¸ü¼ÑÄØ£¿ ¸÷ÊãÆð¼û Õâ¸öµÄ¾ßÌåÎÊÌâ¾ßÌå·ÖÎö ¼òµ¥µÄselect ¡¢updateºÍinsertµ±È»sql½â¾öÁË ¸´ÔӵķÅÔÚsql·þÎñ¶ËÓ¦¸ÃºÃµã Â¥Ö÷Çë²ÎÔÄ http://msdn.micr ......