摘要：with cte as(select *,row_number() over(partition by id order by id)rn from [chengpinid])delete cte where rn>1 阅读全文

摘要：可以使用动态sql来查询。如：declare @tablename varchar(20)declare @sql nvarchar(2000)set @tablename='users'set @sql=N'select * from ' +@tablename+ ''exec sp_execut... 阅读全文