存储过程拆分字符串代码,MSSQL代码库,德仔网

代码语言

代码分类

【MSSQL】存储过程拆分字符串

作者:mcgtts / 发布于2013/12/31/ 839

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:    Allen
-- Create date: 2008-6-11
-- Description:  批量导入客户
-- =============================================
Create PROCEDURE [dbo].[ImportCustomer]
  @strTel varchar(8000),
  @strName varchar(8000),
  @strUserName varchar(50),
  @groupID int
AS
BEGIN
  declare @count int
  declare @tempTel varchar(20)
  declare @tempName varchar(20)
  create table #temp(id int IDENTITY(1,1) NOT NULL primary key,tel varchar(20))
  declare @strsql as varchar(8000)
  select @strsql=''   select @strsql='insert into #temp values ('''+replace(@strTel,',','''); insert into #temp values (''')+''')'
   exec (@strsql)
    create table #temp1(id int IDENTITY(1,1) NOT NULL primary key,[name] varchar(20))
  declare @strsq2 as varchar(8000)
  select @strsq2=''   select @strsq2='insert into #temp1 values ('''+replace(@strName,',','''); insert into #temp1 values (''')+''')'
   exec (@strsq2)
  select @count = count(*) from #temp
  while(@count>0)
   BEGIN
    select @tempTel = tel from #temp where id=@count
    select @tempName = [Name] from #temp1 where id=@count
    insert into dbo.SendCustomer(Tel,[Name],FirstDate,EndDate,UserName)     values(@tempTel,@tempName,getdate(),getdate(),@strUserName)
    insert into dbo.SendGroupCus(Tel,GroupID) values(@tempTel,@groupID)
    Set @count = @count-1
  END
  drop table #temp
  drop table #temp1
END

试试其它关键字

　拆分字符串　

同语言下

可能有用的

mcgtts贡献的其它代码(6)