摘要:
因为急需删除数据库里面的所有东西,随即写了这些代码,不知道有没有人用得着,我用的是SQLServer2008R2的数据库:declare @count int select ROW_NUMBER() over(order by name) as rows , name into #t1 from sysobjects where xtype='p' select @count = COUNT(*) from #t1 declare @tablename varchar(80) while(@count >0) begin select @tab... 阅读全文