清除数据库里面所有用户表的数据

declare @name varchar(8000)
declare cursor_a cursor for select  name from sysobjects  where xtype='U'
open  cursor_a
fetch next from cursor_a into @name
while @@fetch_status=0
begin 
  exec('delete from  '+@name)
  fetch next  from cursor_a into @name
end
close cursor_a
deallocate cursor_a

可随意转载，欢迎署名！