摘要：declare @max integer,@id integerdeclare cur_rows cursor local for select id,count(*) from 表名 group by id having count(*) > 1open cur_rowsfetch cur_rows into @id,@maxwhile @@fetch_status=0beginselect @max = @max -1set rowcount @maxdelete from 表名 where id = @idfetch cur_rows into @id,@maxendclose c 阅读全文

摘要：删除表use 数据库名declare mycur cursor local for select [name] from dbo.sysobjects where xtype='U'declare @name varchar(100)OPEN mycurFETCH NEXT from mycur into @nameWHILE @@FETCH_STATUS = 0 BEGIN exec('drop table ' + @name)FETCH NEXT from mycur into @nameEND CLOSE mycur删除视图use 数据库名declare 阅读全文