分割字符串.docVIP

ò?′?′￠1y3ì?DóD3??2?êy è???￡o ALTER PROCEDURE Pro_AddIDS( @IDS varchar(255), @IDName varchar(50), @IDLevel int ) ???D@IDS=1,5,9,6,10?a?ùμ?êy?Y￡?Dèòa???aD?êy?Y·???3?à′￡?2?μ?ò???±í?D?á11è???￡o CREATE TABLE IDS ( ID INT, IDName VARCHAR(50), IDLevel int ) ?ùéè￡o@IDS=1,5,9,6,10￡?IDName =hello μ?μ?è????á1? /* IDS IDName IDLevel ----------- -------------------------------------------------- 1 hello null 5 hello null 9 hello null 6 hello null 10 hello null ??°????|￡?D?D?￡? è?o???2006-01-12|2006-02-13|2006-03-15|2006-11-11|2003-1-1°′|·???3é 2006-01-12 2006-02-13 2006-03-15 2006-11-11 2003-1-1 declare @Days varchar(4000) declare @tmpDay varchar(10) set @Days=2006-01-12|2006-02-13|2006-03-15|2006-11-11|2003-1-1 set @tmpDay= declare @i int set @i=0 while @ilen(@Days) begin set @i=@i+1 if SUBSTRING(@Days,@i,1)=| begin print left(@Days,@i-1) set @Days=SUBSTRING(@Days,@i+1,len(@Days)) set @i=0 end end print @Days ê?3??á1?￡o 2006-01-12 2006-02-13 2006-03-15 2006-11-11 2003-1-1 ò?×???D??￠°üà¨è???￡oà?èy|à?èy￡à|1???|μ￥??μ??·| ?ò??2é?ˉó?(Select)??áD3?à?èy?°μ￥??μ??·μ?·?·¨￡? create table #t(c1 varchar(100)) insert into #t select li4|33@com|mircrosoft|china| insert into #t select zhang3|zhang3@163.com|IBM|USA| insert into #t select à?èy|à?èy￡à|1???|μ￥??μ??·| select substring(c1,1,charindex(|,c1)-1) as name, reverse(substring(reverse(c1) , 2 , charindex(| , reverse(c1) , 2) - 2)) as address from #t drop table #t name address ----- ------- li4 china zhang3 USA à?èy μ￥??μ??· ￡¨?ùó°?ìμ?DDêy?a 3 DD￡? declare @s varchar(20) set @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 2???￡o create table tblTest(PdID int,PdName varchar(100)) insert tblTest select 1,A10 union all sele