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