存储过程实现批量删除

ALTER proc [dbo].[P_DelAll]
@AllId nvarchar(50)
as
declare @Sql nvarchar(200)
set @Sql='DELETE Curricula WHERE CurriculaId in ('+@AllId+')' exec(@Sql)