.spit() 在存储过程 中的实现

 CREATE PROCEDURE 存储过程名
 -- Add the parameters for the stored procedure here

AS
Declare @websiteid int
    BEGIN TRANSACTION
  
          Select @websiteid=@@identity
 IF (@@ERROR <> 0) GOTO on_error

declare @curr int
declare @prev int

set @curr=1
set @prev=1
while  @prev < len(@areacode)
begin
set @curr=charindex(',',@areacode,@prev)
if @curr>@prev
insert — select —,substring(@areacode,@prev,@curr-@prev)  
else
begin
insert  — select —,substring(@areacode,@prev,len(@areacode)-@prev+1)
break
end
set @prev=@curr+1
end
-------------------
set @curr=1
set @prev=1
while  @prev < len(@industrycode)
begin
set @curr=charindex('||',@industrycode,@prev)
if @curr>@prev
insert — select @websiteid,substring(@industrycode,@prev,@curr-@prev)  
else
begin
insert  —  select @websiteid,substring(@industrycode,@prev,len(@industrycode)-@prev+1)  --不大明白
break
end
set @prev=@curr+2
end

        IF @@error <> 0  --发生错误
        BEGIN
            ROLLBACK TRANSACTION
            RETURN 0
        END
        ELSE
        BEGIN
            COMMIT TRANSACTION
            RETURN 1    --执行成功
       END