在此同时求点击:点击点击点击。。。
----sql游标--删除所有的表
declare @tablename varchar(100)
Declare cur_tablename Cursor For Select [name] From sysobjects where type='U' and [name] like 'dnt_%'
Open cur_tablename
Fetch next From cur_tablename Into @tablename
While @@Fetch_Status=0
Begin
exec('drop table '+@tablename)
Fetch From cur_tablename into @tablename
End
Close cur_tablename
Deallocate cur_tablename
----sql游标--删除所有的存储过程
declare @tablename varchar(100)
Declare cur_tablename Cursor For Select [name] From sysobjects where type='P' and [name] like 'dnt_%'
Open cur_tablename
Fetch next From cur_tablename Into @tablename
While @@Fetch_Status=0
Begin
exec('drop proc '+@tablename)
Fetch From cur_tablename into @tablename
End
Close cur_tablename
Deallocate cur_tablename