欧美bbbwbbbw肥妇,免费乱码人妻系列日韩,一级黄片

快速刪除DiscuzNT論壇數(shù)據(jù)表和存儲過程

  發(fā)布時間：2011-12-22 00:08:14   作者：佚名   我要評論
公司的一個客戶要求把DiscuzNT從現(xiàn)有網(wǎng)站刪除（數(shù)據(jù)和頁面），頁面簡單，F(xiàn)TP連接上去刪除就可以了，數(shù)據(jù)表的刪除就有點糾結(jié)了：我的DNT論壇是和現(xiàn)有的網(wǎng)站系統(tǒng)共用的一個數(shù)據(jù)庫
本來想一個一個刪除的，打開數(shù)據(jù)庫一看那么多的表和存儲過程，就放棄這種笨辦法了，于是決定用SQL語句來搞定。代碼如下：

復(fù)制代碼
代碼如下:

-----------------------------刪除數(shù)據(jù)表---------------------
DECLARE @au_lname VARCHAR(40),@SQLString NVARCHAR(500)
DECLARE tb CURSOR FOR
SELECT name FROM sysobjects WHERE xtype='U' and name like 'dnt%'
OPEN tb
-- Perform the FIRST FETCH.
FETCH NEXT FROM tb INTO @au_lname
-- CHECK @@FETCH_STATUS TO see IF there ARE ANY more ROWS TO FETCH.
WHILE @@FETCH_STATUS = 0
BEGIN
-- This IS executed AS long AS the previous FETCH succeeds.
FETCH NEXT FROM tb INTO @au_lname
SET @SQLString='DROP TABLE '+ @au_lname
EXEC sp_executesql @SQLString
--DROP TABLE @au_lname
END
CLOSE tb
DEALLOCATE tb
GO
-----------------------------刪除存儲過程---------------------
DECLARE @au_lname VARCHAR(40),@SQLString NVARCHAR(500)
DECLARE tb CURSOR FOR
SELECT name FROM sysobjects WHERE xtype='p' and name like 'dnt%'
OPEN tb
-- Perform the FIRST FETCH.
FETCH NEXT FROM tb INTO @au_lname
-- CHECK @@FETCH_STATUS TO see IF there ARE ANY more ROWS TO FETCH.
WHILE @@FETCH_STATUS = 0
BEGIN
-- This IS executed AS long AS the previous FETCH succeeds.
FETCH NEXT FROM tb INTO @au_lname
SET @SQLString='DROP PROCEDURE '+ @au_lname
EXEC sp_executesql @SQLString
--DROP TABLE @au_lname
END
CLOSE tb
DEALLOCATE tb
GO

相關(guān)文章

最新評論