create proc p_delallusertabledata
as
begin
declare @name varchar(20)
declare cur cursor for
select name from sysobjects where xtype='u' and status>=0
declare @sql varchar(20)
open cur
fetch cur into @name
while @@fetch_status=0
begin
set @sql='delete ' +@name;
exec(@sql)
fetch cur into @name
end
close cur
deallocate cur
end
go
exec p_delallusertabledata
as
begin
declare @name varchar(20)
declare cur cursor for
select name from sysobjects where xtype='u' and status>=0
declare @sql varchar(20)
open cur
fetch cur into @name
while @@fetch_status=0
begin
set @sql='delete ' +@name;
exec(@sql)
fetch cur into @name
end
close cur
deallocate cur
end
go
exec p_delallusertabledata
扫一扫
1010
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
