摘要:刪除資料庫所有資料表的資料
DECLARE @tbl_name nvarchar(800)
DECLARE @CName nvarchar(200)
DECLARE myCursor CURSOR FOR --將資料一筆一筆取出來處理的條件
SELECT name
FROM sysobjects
where type='U'
open myCursor
FETCH NEXT FROM myCursor INTO @CName
WHILE @@FETCH_STATUS = 0
begin
set @tbl_name = 'delete from ' + @CName
exec(@tbl_name)
FETCH NEXT FROM myCursor INTO @CName
end
CLOSE myCursor
DEALLOCATE myCursor
