SQL实用技巧：如何分割字符串

create function f_split(@c varchar(2000),@split varchar(2)) <br style="font-family: Helvetica, Tahoma, Arial, STXihei, 华文细黑, ‘Microsoft YaHei‘, 微软雅黑, SimSun, 宋体, Heiti, 黑体, sans-serif; box-sizing: border-box;">returns @t table(col varchar(20)) <br style="font-family: Helvetica, Tahoma, Arial, STXihei, 华文细黑, ‘Microsoft YaHei‘, 微软雅黑, SimSun, 宋体, Heiti, 黑体, sans-serif; box-sizing: border-box;">as <br style="font-family: Helvetica, Tahoma, Arial, STXihei, 华文细黑, ‘Microsoft YaHei‘, 微软雅黑, SimSun, 宋体, Heiti, 黑体, sans-serif; box-sizing: border-box;">    begin <br style="font-family: Helvetica, Tahoma, Arial, STXihei, 华文细黑, ‘Microsoft YaHei‘, 微软雅黑, SimSun, 宋体, Heiti, 黑体, sans-serif; box-sizing: border-box;">    <br style="font-family: Helvetica, Tahoma, Arial, STXihei, 华文细黑, ‘Microsoft YaHei‘, 微软雅黑, SimSun, 宋体, Heiti, 黑体, sans-serif; box-sizing: border-box;">      while(charindex(@split,@c)<>0) <br style="font-family: Helvetica, Tahoma, Arial, STXihei, 华文细黑, ‘Microsoft YaHei‘, 微软雅黑, SimSun, 宋体, Heiti, 黑体, sans-serif; box-sizing: border-box;">        begin <br style="font-family: Helvetica, Tahoma, Arial, STXihei, 华文细黑, ‘Microsoft YaHei‘, 微软雅黑, SimSun, 宋体, Heiti, 黑体, sans-serif; box-sizing: border-box;">          insert @t(col) values (substring(@c,1,charindex(@split,@c)-1)) <br style="font-family: Helvetica, Tahoma, Arial, STXihei, 华文细黑, ‘Microsoft YaHei‘, 微软雅黑, SimSun, 宋体, Heiti, 黑体, sans-serif; box-sizing: border-box;">          set @c = stuff(@c,1,charindex(@split,@c),‘‘) <br style="font-family: Helvetica, Tahoma, Arial, STXihei, 华文细黑, ‘Microsoft YaHei‘, 微软雅黑, SimSun, 宋体, Heiti, 黑体, sans-serif; box-sizing: border-box;">        end <br style="font-family: Helvetica, Tahoma, Arial, STXihei, 华文细黑, ‘Microsoft YaHei‘, 微软雅黑, SimSun, 宋体, Heiti, 黑体, sans-serif; box-sizing: border-box;">      insert @t(col) values (@c) <br style="font-family: Helvetica, Tahoma, Arial, STXihei, 华文细黑, ‘Microsoft YaHei‘, 微软雅黑, SimSun, 宋体, Heiti, 黑体, sans-serif; box-sizing: border-box;">      return <br style="font-family: Helvetica, Tahoma, Arial, STXihei, 华文细黑, ‘Microsoft YaHei‘, 微软雅黑, SimSun, 宋体, Heiti, 黑体, sans-serif; box-sizing: border-box;">    end <br style="font-family: Helvetica, Tahoma, Arial, STXihei, 华文细黑, ‘Microsoft YaHei‘, 微软雅黑, SimSun, 宋体, Heiti, 黑体, sans-serif; box-sizing: border-box;">go <br style="font-family: Helvetica, Tahoma, Arial, STXihei, 华文细黑, ‘Microsoft YaHei‘, 微软雅黑, SimSun, 宋体, Heiti, 黑体, sans-serif; box-sizing: border-box;">    <br style="font-family: Helvetica, Tahoma, Arial, STXihei, 华文细黑, ‘Microsoft YaHei‘, 微软雅黑, SimSun, 宋体, Heiti, 黑体, sans-serif; box-sizing: border-box;">select * from dbo.f_split(‘dfkd,dfdkdf,dfdkf,dffjk‘,‘,‘) <br style="font-family: Helvetica, Tahoma, Arial, STXihei, 华文细黑, ‘Microsoft YaHei‘, 微软雅黑, SimSun, 宋体, Heiti, 黑体, sans-serif; box-sizing: border-box;">    <br style="font-family: Helvetica, Tahoma, Arial, STXihei, 华文细黑, ‘Microsoft YaHei‘, 微软雅黑, SimSun, 宋体, Heiti, 黑体, sans-serif; box-sizing: border-box;">drop function f_split

SQL实用技巧：如何分割字符串

标签：fun   set   att   char   creat   mat   cti   microsoft   box