declare cls_cursor cursor for select name from sysobjects where name like 'iesc%' open cls_cursordeclare @tab_name varchar(20) fetch next from cls_cursor into @tab_name while @@fetch_status=0 begin exec('delete from '+@tab_name) end fetch next from cls_cursor into @tab_name close cls_cursor deallocate cls_cursor
用这个:declare cls_cursor cursor for select name from sysobjects where name like 'iesc%' open cls_cursordeclare @tab_name varchar(20) fetch next from cls_cursor into @tab_name while @@fetch_status=0 begin exec('TRUNCATE TABLE '+@tab_name) end fetch next from cls_cursor into @tab_name close cls_cursor deallocate cls_cursor
to大力: 不好意思啊,已成功了,还有个问题是如何使它执行完就结束了呢??tks!!
declare cls_cursor cursor for select name from sysobjects where name like 'iesc%' open cls_cursordeclare @tab_name varchar(20) fetch next from cls_cursor into @tab_name while @@fetch_status=0 begin exec('delete from '+@tab_name) --改的地方 fetch next from cls_cursor into @tab_name endclose cls_cursor deallocate cls_cursor
declare cls_cursor scroll cursor select name from sysobjects where name like 'iesc%' open cls_cursordeclare @tab_name varchar(20) fetch next from cls_cursor into @tab_name while @@fetch_status=0 begin delete from @tab_name end fetch next from cls_cursor into @tab_name close cls_cursor deallocate cls_cursor
select name from sysobjects where name like 'iesc%'
open cls_cursordeclare @tab_name varchar(20)
fetch next from cls_cursor into @tab_name
while @@fetch_status=0
begin
exec('delete from '+@tab_name)
end
fetch next from cls_cursor into @tab_name
close cls_cursor
deallocate cls_cursor
select name from sysobjects where name like 'iesc%'
open cls_cursordeclare @tab_name varchar(20)
fetch next from cls_cursor into @tab_name
while @@fetch_status=0
begin
exec('TRUNCATE TABLE '+@tab_name)
end
fetch next from cls_cursor into @tab_name
close cls_cursor
deallocate cls_cursor
不好意思啊,已成功了,还有个问题是如何使它执行完就结束了呢??tks!!
select name from sysobjects where name like 'iesc%'
open cls_cursordeclare @tab_name varchar(20)
fetch next from cls_cursor into @tab_name
while @@fetch_status=0
begin
exec('delete from '+@tab_name)
--改的地方
fetch next from cls_cursor into @tab_name
endclose cls_cursor
deallocate cls_cursor
select name from sysobjects where name like 'iesc%'
open cls_cursordeclare @tab_name varchar(20)
fetch next from cls_cursor into @tab_name
while @@fetch_status=0
begin
delete from @tab_name
end
fetch next from cls_cursor into @tab_name
close cls_cursor
deallocate cls_cursor