-----------------------------------------------------------------------------------------------

drop table a
create table a
(
no VARCHAR(20),
kqrq VARCHAR(20),
jzno VARCHAR(20),
qjxs VARCHAR(20)
)

delete from a

--------------------------------------------
 create procedure sp_split_string
 (
     @string        NVARCHAR(500),
     @stringv2      NVARCHAR(500),
     @stringv3      NVARCHAR(500)
  )
 AS
 BEGIN
     DECLARE @object_no     nvarchar(500)
     DECLARE @object_jzno   nvarchar(500)
     DECLARE @object_qjxs   nvarchar(500)
     DECLARE @object_kqrq   nvarchar(500)
     DECLARE    @i          INT
     DECLARE    @len        INT   
     print @string
     IF (@string IS NULL) OR (LTRIM(@string) = '') 
         RETURN
    
     WHILE CHARINDEX('/',@string) > 0
         BEGIN

                          
             SET @len = LEN(@string)
             SET @i = CHARINDEX('/', @string)
             SET @object_no = @stringv2  
             SET @object_jzno = LEFT(@string, 4)
             SET @object_qjxs = SUBSTRING(@string, 5,@i-1-4) --@i-1 是该单元中的最后一个字符在该单元的位置 LEFT(@string, @i-1)
             SET @object_kqrq = @stringv3

             INSERT INTO a (no,kqrq,jzno,qjxs) VALUES (@object_no,@object_kqrq,@object_jzno,@object_qjxs)   --做修改，改成需要的sql语句即可
             SET @string = RIGHT(@string, @len - @i)
         END

     IF CHARINDEX('/',@string) = 0
     RETURN 

     SET @object_no = @stringv2
     SET @object_jzno = LEFT(@string, 4)
     SET @object_qjxs = SUBSTRING(@string, 5,@i-1-4)
     SET @object_kqrq = @stringv3
     INSERT INTO a (no,kqrq,jzno,qjxs) VALUES (@object_no,@object_kqrq,@object_jzno,@object_qjxs)  --做修改，改成需要的sql语句即可
 END
 go
---------------------------------------------
 

declare   @dav1   as   varchar(50)  
declare   @dav2   as   varchar(10)
declare   @dav3   as   varchar(10)  
 declare   cursor5   cursor   for SELECT jzno,no,kqrq FROM rb200802 where jzno is not null order by no,kqrq 
     
  open cursor5  
   
  fetch   next   from  cursor5   into   @dav1,@dav2,@dav3
 /*检查@@FETCH_STATUS以确定是否还可以继续取数*/  
  while   @@fetch_status=0  
  begin 
     exec sp_split_string @dav1,@dav2,@dav3
 
                     
     fetch   next   from       cursor5   into   @dav1,@dav2,@dav3  
  end   
    
close     cursor5  
deallocate   cursor5

----------------------------------------------------------------------------------------

select * from  a

--------------------------------------------------------------------------------

文章来源:http://bbs.fzonet.com/rcds/ShowPost.asp?ThreadID=1649