清空sql server
数据库所有的表记录
将某一个数据库
所有的用户表的记录都删除了
declare curTable cursor for select name from sysobjects where xtype='U' declare @t_table varchar(100) declare @t_sql varchar(200) open curTable fetch curTable into @t_table while @@fetch_status = 0 begin set @t_sql='delete from ' + @t_table exec (@t_sql) fetch curTable into @t_table end deallocate curTable