sql使用in批量删除

if exists (select * from sys.procedures where object_id = OBJECT_ID(N'[Report].[prAreaOutAndInSel_New20210825]'))
drop proc [Report].[prAreaOutAndInSel_New20210825]
go
CREATE PROCEDURE [Report].[prAreaOutAndInSel_New20210825]
-- =============================================
-- Author:  马鹏
-- Create date: 2021-10-09
-- Description: 删除作业路线
-- =============================================
ALTER PROCEDURE [HL].[DelAlarmRoad]
	@Code VARCHAR(2000),
	@O_RETURN INT = -1 OUTPUT--返回值
AS
BEGIN
	
	SET NOCOUNT ON;	
	--开始一个事务OK   
	BEGIN TRAN OK
	
	--批量删除
	UPDATE HL.AlarmRoad SET Isvalid=0 WHERE CHARINDEX(','   +   Code  +   ',',','   +   @Code   +   ',')>0  
	DELETE FROM HL.RoadJobType WHERE CHARINDEX(','   +   RoadCode   +   ',',','   +   @Code   +   ',')>0  

	--判断修改数据有没有出错 =0没有异常
	IF(@@ERROR<>0)
    BEGIN
	     ROLLBACK TRAN  OK  -- 回滚事务
		 SET @O_RETURN = -1;
	END
	ELSE
	BEGIN
		 COMMIT TRAN OK --提交事务
		 SET @O_RETURN = 0;
	END 
	--print @@ROWCOUNT	
END

调用

DECLARE	@return_value int,
		@O_RETURN int

SELECT	@O_RETURN = -1

EXEC	@return_value = [HL].[DelAlarmRoad]
		@Code = '8501421C-80F8-4E2F-B420-A3A5A0707C62,8501421C-80F8-4E2F-B420-A3A5A0707C61',
		@O_RETURN = @O_RETURN OUTPUT

SELECT	@O_RETURN as N'@O_RETURN'

SELECT	'Return Value' = @return_value

GO