use 大分県佐伯市NoukaContext
GO
declare @sql varchar(max)
while (select count(*) from sysobjects where type='U')>0
begin
SELECT @sql='truncate table ' + name
FROM sysobjects
WHERE (type = 'U')
ORDER BY 'truncate table ' + name
exec(@sql)
end
GO
posted on 2017-01-16 17:53
Ying-er 阅读(125)
评论(0) 编辑 收藏