SQL Server custom functions + stored procedures for bulk deletion

Due to the needs of the project, many modules have to implement the bulk deletion function. To facilitate the invocation of the module, the bulk Delete method is written as a custom function. directly on the code.

Custom functions:

ALTER FUNCTION [dbo]. [Func_splitbyid] (@str varchar (), @split varchar (10))--Passed ID string-  -split flag returns @t table (id int)  --Returns a table Asbegin    DECLARE @x XML  --splicing    SET @x = CONVERT (XML, ' <items><item id= "' + REPLACE (@str, @split, '"/><item id= "') + ' "/></items> ')    INSERT into @t SELECT x.item.value (' @id [1] ', ' int. ') from @x.nodes ('//items/item ') as x (item)    RETURN END

Bulk Delete Memory Call Custom function:

ALTER proc [dbo]. [Pro_deluserinfo] (@id varchar (max)) Asbeginupdate Tbl_member set enable=0 where ID in (SELECT * from Dbo.func_splitbyid (@id, ', ')) end

SQL Server custom functions + stored procedures for bulk deletion