紧急求救！！！！

[andy_123]

CREATE PROCEDURE SP_DeleteMultiMessage
@ID nvarchar(500) ,
@UserID INT
AS
DELETE FROM MessageReceiveList where RecID in(@ID)
end
上面的ＳＰ是用户删除多条记录,@ID 是以逗号分割的多个记录ID
执行会报错：
将 nvarchar 值 '584,583'转换为数据类型为 int 的列时发生语法错误
　
如何解决这个问题？

[sql_sf]

CREATE PROCEDURE SP_DeleteMultiMessage
@ID nvarchar(500) ,
@UserID INT
AS  
DELETE FROM MessageReceiveList where charindex(','+ltrim(RecID)+',',','+@ID+',')>0
end

[sql_sf]

CREATE PROCEDURE SP_DeleteMultiMessage
@ID nvarchar(500) ,
@UserID INT
AS  
exec('DELETE FROM MessageReceiveList where RecID in('+@ID+')')