alter proc dbo.truncatedatabase @sqlexecute varchar(3000)='select * from %tablename%' as begin declare @tablename varchar(100) ,@sql varchar(3000)
--定義游標 declare mycur cursor for select name from dbo.sysobjects where xtype='u' --打開 open mycur fetch next from mycur into @tablename while @@fetch_status=0 begin set @sql=replace(@sqlexecute,'%tablename%',@tablename)
--執行操作 print @sql execute(@sql) --到下一個表 fetch next from mycur into @tablename end close mycur deallocate mycur
