万能批量删除

USE [CreditMall]
GO

/****** Object:  StoredProcedure [dbo].[proc_Delete]    Script Date: 07/27/2018 19:36:17 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

 

create proc [dbo].[proc_Delete]
@TableName varchar(50),
@Id varchar(5000)
as
begin
 declare @strSql varchar(5000)
 
 
 declare @sql varchar(4000)

    set @sql='select col='''+ replace(@Id,',',''' union all select ''')+''''
   
    if OBJECT_ID('tempdb..#DelID') is not null
        drop table #DelID
 create table #DelID(ID VARCHAR(36))
 
 insert into #DelID exec(@sql)
 
 set @strSql = 'delete from '+@TableName+' where ID in ( select ID from #DelID)'
 
 exec(@strSql)
end

GO

转载于:https://www.cnblogs.com/xuyuequan/p/9388632.html