当前位置: 代码迷 >> Sql Server >> 怎么根据逗号拆分多条数据
  详细解决方案

怎么根据逗号拆分多条数据

热度:95   发布时间:2016-04-24 18:42:17.0
如何根据逗号拆分多条数据

    area                                            date
黑龙江,吉林,辽宁                                            2013-5-1
内蒙古,北京                                                 2014-1-1
福建,浙江                                                   2012-4-2
天津,河北,河南,山东,威海,青岛,哈尔滨,武清区                2015-3-16
新疆                                                        2014-9-12
辽宁,河南,威海,沈阳,大连                                   2015-2-1     


现在想得到的数据是,如何根据逗号拆分多条数据

area                                                date
黑龙江                                                      2013-5-1
吉林                                                        2013-5-1
辽宁                                                        2013-5-1
内蒙古                                                      2014-1-1
北京                                                        2014-1-1
福建                                                        2012-4-2
浙江                                                        2012-4-2
天津                                                        2015-3-16
河北                                                        2015-3-16
河南                                                        2015-3-16
山东                                                        2015-3-16
  相关解决方案