SqlServer 解决多条重复数据无法只删除一条或几条问题

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

-- =============================================
-- Author:        WangXinXi
-- Create date: 2019-03-01
-- Description:    解决多条重复数据问题，重复只保留一条数据，
/*

带Where
[DeleteTbDataTrs] 'aaa',' WHERE name = ''a''  '

不带Where
[DeleteTbDataTrs] 'aaa',''

*/
-- =============================================
ALTER PROCEDURE [dbo].[DeleteTbDataTrs]
    @tableName nvarchar(50),    -- 表名
    @whereStr nvarchar(50)        -- where 语句
AS

Declare @tbzd nvarchar(max)
Declare @Sql nvarchar(max)

BEGIN
    set @tbzd = (select stuff((
                    select ','+name
                    from syscolumns
                    WHERE id=Object_Id(''set ANSI_NULLS ON
set QUOTED_IDENTIFIER O