Declare @tmpTableName varchar(100)
Declare cur_delAllTable CURSOR FOR
SELECT name FROM master..sysobjects
WHERE type = 'U';Open cur_delAllTable
Fetch Next From cur_delAllTable Into @tmpTableName
While @@Fetch_Status = 0
Begin
--Truncate Table @tmpTableName
exec('Delete From '+@tmpTableName)
Fetch Next From cur_delAllTable Into @tmpTableName
End
Close cur_delAllTable
Deallocate cur_delAllTable
GO
Declare cur_delAllTable CURSOR FOR
SELECT name FROM master..sysobjects
WHERE type = 'U';Open cur_delAllTable
Fetch Next From cur_delAllTable Into @tmpTableName
While @@Fetch_Status = 0
Begin
--Truncate Table @tmpTableName
exec('Delete From '+@tmpTableName)
Fetch Next From cur_delAllTable Into @tmpTableName
End
Close cur_delAllTable
Deallocate cur_delAllTable
GO
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货