清空所有数据(适合于数据初始化)

 

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[P_ClearAllData]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[P_ClearAllData]
GO

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO

CREATE PROCEDURE P_ClearAllData

 AS

declare   my_cursor cursor for  
  select t.name from sysobjects t where t.type='U'  

  declare   @table   varchar(200)  
  declare   @str   varchar(200)  
   
  open my_cursor  
  fetch my_cursor into @table 

  while (@@FETCH_STATUS=0)  
  begin  
 if (@table<>'T_AllCountries' and  @table<>'T_Countrys' and @table<>'T_Nations' and @table<>'dtproperties')
 begin 
    select   @str='Delete from  '+@table
    exec(@str)
 end
  fetch   my_cursor into @table
  end  
  close   my_cursor 
  deallocate my_cursor
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

 

转载于:https://www.cnblogs.com/yanzi/articles/1745259.html