A :
select *
from the (SELECT cast(DS4.SPLIT(TC_PLCKEX2005, ',') as stringTable) FROM DS4.TC_PLCKEX2_FILE WHERE TC_PLCKEX2001 = 'B530C')B:
select *from table(split('fas,asdf,asdf',','))
本文共 270 字，大约阅读时间需要 1 分钟。
A :
select *
from the (SELECT cast(DS4.SPLIT(TC_PLCKEX2005, ',') as stringTable) FROM DS4.TC_PLCKEX2_FILE WHERE TC_PLCKEX2001 = 'B530C')B:
select *from table(split('fas,asdf,asdf',','))
转载于:https://www.cnblogs.com/Mayvar/archive/2011/06/17/wanghonghua_201106170331.html