set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[pro_Delete]
@TableName nvarchar(50), --要删除的表的名称
@StrWhere nvarchar(500) --删除条件
AS
BEGIN
Declare @SqlTemp nvarchar(1000) ----存放动态生成的SQL语句
set @SqlTemp= 'delete from ' + @TableName + ' where ' + @StrWhere
exec sp_executesql @SqlTemp
END