写的存储过程，接收的参数的一个字符串，通过分割字符串从而实现批量删除。

IF (@operation = 'delete')BEGINDECLARE @temp nvarchar(200)DECLARE @splitchar nvarchar(1)SET @splitchar=','SET @userId=@userId+@splitcharWHILE CHARINDEX(@splitchar,@userId)>0BEGINSET @temp=SUBSTRING(@userId,1,CHARINDEX(@splitchar,@userId)-1)IF(LEN(@temp)>0)BEGINPRINT(@temp)DELETE from TB_user WHERE user_id =@temp;ENDSET @userId=RIGHT(@userId,LEN(@userId)-CHARINDEX(@splitchar,@userId))PRINT(@userId)ENDEND

用到的函数有：CHARINDEX();LEN();RIGHT();SUBSTRING（）
charindex(expression1 , expression2 )表示：
从expression2字符串中指定的位置处开始查找是否包含expression1字符串。如果能够从expression2字符串中查找到expression1字符串则返回expression1在
expression2出现的位置；反之，返回0

LEN(expression1 )表示：返回expression1 的长度；

RIGHT(expression,number）表示：从expression右边开始，返回长度为number的字符串。

SUBSTRING(expression, start, length)表示：返回从expression的start位置开始截取长度为length 的字符串。

附上完整的存储过程，是用的操作的，包含增加用户，修改用户，批量删除用户。
文件：sp_query_掌上微课_用户操作.sql

USE [ZSWK]
GO
/****** Object:  StoredProcedure [dbo].[sp_query_掌上微课_用户操作]    Script Date: 12/05/2018 11:10:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO-- exec sp_query_掌上微课_用户操作 'insert','','20181204测试','123456','','测试001','男','','','1','','','123',''
-- exec sp_query_掌上微课_用户操作 'update','10','test001','','','','','','null','','','','',''
-- exec sp_query_掌上微课_用户操作 'delete','11','null','null','null','null','null','null','null','null','null','null','null','null' 
ALTER PROC [dbo].[sp_query_掌上微课_用户操作]@operation varchar(255),@userId  varchar(255),@userName  varchar(255),@password  varchar(255),@phone varchar(255),@fullname varchar(255),@sex varchar(255),@area varchar(255),@createAt varchar(255),@isTeacher varchar(255),@teacherInfo varchar(4000),@icon varchar(4000),@empNumber varchar(255),@userAccount varchar(255)
ASBEGINSET NOCOUNT ONIF (@operation = 'insert')BEGININSERT INTO TB_user(user_name,password,fullname,phone,sex,area,create_at,isTeacher,teacher_info,icon,empNumber,userAccount)VALUES (@userName,@password, @fullname, @phone,@sex,@area,@createAt,@isTeacher,@teacherInfo,@icon,@empNumber,@userAccount)ENDIF (@operation = 'delete')BEGINDECLARE @temp nvarchar(200)DECLARE @splitchar nvarchar(1)SET @splitchar=','SET @userId=@userId+@splitcharWHILE CHARINDEX(@splitchar,@userId)>0BEGINSET @temp=SUBSTRING(@userId,1,CHARINDEX(@splitchar,@userId)-1)IF(LEN(@temp)>0)BEGINPRINT(@temp)DELETE from TB_user WHERE user_id =@temp;ENDSET @userId=RIGHT(@userId,LEN(@userId)-CHARINDEX(@splitchar,@userId))PRINT(@userId)ENDENDIF (@operation = 'update')BEGINDECLARE @sql VARCHAR(5000)DECLARE @whereSql VARCHAR(5000)SET @sql = 'UPDATE TB_user SET'SET @whereSql = ''IF ( @userName !='NULL' and @userName != '')BEGINSET @whereSql =@whereSql+ ' user_name = '+''''+@userName+''''+','ENDIF ( @password !='NULL')BEGINSET @whereSql =@whereSql+ ' password = '+''''+@password+''''+','ENDIF ( @phone !='NULL')BEGINSET @whereSql =@whereSql+ ' phone = '+''''+@phone+''''+','ENDIF ( @fullname !='NULL')BEGINSET @whereSql =@whereSql+ ' fullname = '+''''+@fullname+''''+','ENDIF ( @sex !='NULL')BEGINSET @whereSql =@whereSql+ ' sex = '+''''+@sex+''''+','ENDIF ( @area !='NULL')BEGINSET @whereSql =@whereSql+ ' area = '+''''+@area+''''+','ENDIF ( @createAt !='NULL')BEGINSET @whereSql =@whereSql+ ' create_at = '+''''+@createAt+''''+','ENDIF ( @isTeacher !='NULL')BEGINSET @whereSql =@whereSql+ ' isTeacher = '+''''+@isTeacher+''''+','ENDIF ( @teacherInfo !='NULL')BEGINSET @whereSql =@whereSql+ ' teacher_info = '+''''+@teacherInfo+''''+','ENDIF ( @icon !='NULL')BEGINSET @whereSql =@whereSql+ ' icon = '+''''+@icon+''''+','ENDIF ( @empNumber !='NULL')BEGINSET @whereSql =@whereSql+ ' empNumber = '+''''+@empNumber+''''+','ENDIF ( @userAccount !='NULL')BEGINSET @whereSql =@whereSql+ ' userAccount = '+''''+@userAccount+''''+','ENDSET  @sql = @sql+@whereSqlIF ( charindex(',',@sql) > 0)BEGINPRINT @sqlSET @sql = SUBSTRING(@sql,0,(LEN(@sql)) )SET @sql = @sql + ' WHERE user_id = '+ @userIdPRINT @sqlEXEC (@sql)ENDELSEBEGINRETURNENDENDEND