declare @str varchar(8000)
set @str= ' '
select @str=@str+ 'truncate table '+name+char(10) from sysobjects where xtype= 'U '
exec(@str)
转载于:https://www.cnblogs.com/dodui/archive/2011/11/04/2236434.html
转载于:https://www.cnblogs.com/dodui/archive/2011/11/04/2236434.html