--使用游标删除所有表内容 set nocount on declare Trun_Cur cursor for select name from sys.tabless declare @PName varchar(100),@SQL varchar(255) open Trun_cur fetch next from Trun_cur into @Pname while @@fetch_status=0 begin set @SQL='truncate table '+@pname exec (@SQL) fetch next from Trun_cur into @Pname end close Trun_cur deallocate Trun_cur set nocount off
http://blog.csdn.net/roy_88/archive/2008/05/21/2467748.aspx
set nocount on
declare Trun_Cur cursor
for select name from sys.tabless
declare @PName varchar(100),@SQL varchar(255)
open Trun_cur
fetch next from Trun_cur into @Pname
while @@fetch_status=0
begin
set @SQL='truncate table '+@pname
exec (@SQL)
fetch next from Trun_cur into @Pname
end
close Trun_cur
deallocate Trun_cur
set nocount off
小梁,你给我的哪个连接,能不能修改下!