分割字符串(国外英语资料).doc

分割字符串(国外英语资料) 如下: alter procedure pro _ addids ( @ ids varchar (255) @ idname varchar (50) @ idlevel int ) 其中 @ ids = 1,5,9,6,10 这样的数据, 需要将这些数据分割出来, 插到一张表中结构如下: create table ids ( id int, idname varchar (50) idlevel int ) 假设: @ ids = 1,5,9,6,10, idname = hello 得到如下结果 / * ids idname idlevel -----------. 1 hello null 5 hello null 9 hello null 6 hello null 10 hello null 请帮下忙, 谢谢! 如何将 2006 - 01 - 12 | 2006 - 02 - 13 | 2006 - 03 - 15 | 2006 - 11 - 11 | 2003 - 1 - 1 按 | 分割成 2006 - 01 - 12 2006 - 02 - 13 2006 - 03 15 2006 - 11 - 11 2003 - 1 - 1 dead @ days varchar (4000) dead @ tmpday varchar (10) seen @ days = 2006 - 01 - 12 | 2006 - 02 - 13 | 2006 - 03 - 15 | 2006 - 11 - 11 | 2003 - 1 - 1 seen @ tmpday = dead @ in int seen @ i = 0 while @ len (@ days) begin seen @ in @ = i + 1 if substring (@ - @ i, 1) = | begin print left (@ - @ - 1) seen @ days = substring (@ - @ i + 1, len (@ days)) seen @ i = 0 than than print @ days 输出结果: 2006 - 01 - 12 2006 - 02 - 13 2006 - 03 15 2006 - 11 - 11 2003 - 1 - 1 一字段信息包括如下: 李三 | 李三＠ | 公司 | 单位地址 | 我将查询用 (select) 只列出李三及单位地址的方法? create table # t (c1 varchar (100)) insert into # t select li4 | 33 @ com | mircrosoft | china | insert into # t select zhang3 | zhang3 @ 163.com | ibm | united states | insert into # t select 李三 | 李三＠ | 公司 | 单位地址 | select substring (c1,1, charindex (|, c1) - 1) as name, reverse (substring (reverse (c1), 2, charindex (|, reverse (c1) 2) 2)) as the address from # t drop table # t name address ----- ------- li4 china zhang3 usa 李三 单位地址 (所影响的行数为 3 行) dead @ s varchar (20) seen @ s = 06g512753 - 08 01 select parsename (t.s, 3) part1, parsename (t.s, 2) part2, parsename (t.s, 1) part3 from (select replace (@ s, -, .) as s) t 参考: create table tbltest (pdid int, pdname varchar (100)) insert tbltest select 1, a10 union all select 2, a20, a20s union all select 3, a30, a30k, a30m union all select 4 a301 union all select 5 a301m select * from tbltest go - 建立一个辅助的临时表就可以了 select top 8000 id = identity (int, 1,1) into # fr