1.1

SQLServer 清空某个库所有表

select @n=1
insert #temp(tablename) SELECT distinct sobjects.name
FROM sysobjects sobjects
WHERE sobjects.xtype = 'U'

select @rows = @@rowcount
while @n <= @rows
begin

	declare @tablename nvarchar(50)
	select @tablename = (select tablename from #temp where id = @n)
	--允许将显式值插入表的标识列中 ON-允许  OFF-不允许
	--exec ('set identity_insert '+@tablename+' ON')--打开
	exec ('TRUNCATE TABLE  '+@tablename)
	print(@tablename)
	select @n = @n + 1
end
go
posted @ 2018-11-17 23:22  asml  阅读(1171)  评论(0编辑  收藏  举报
@.@