USE [test]

GO

/****** Object:  StoredProcedure [dbo].[wangchuang]    Script Date: 2016/8/25 14:09:24 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author:        <Author,,Name>

-- Create date: <Create Date,,>

-- Description:    <Description,,>

-- =============================================

ALTER PROCEDURE [dbo].[wangchuang] 

AS

BEGIN

    -- SET NOCOUNT ON added to prevent extra result sets from

    -- interfering with SELECT statements.

    SET NOCOUNT ON;

    declare @strsql varchar()

    declare kindcollection cursor --声明游标

    for  select kind from kind

    open kindcollection    --打开

    declare @noToUpdate varchar()    --声明一个变量，用于读取游标中的值

    fetch next from kindcollection into @noToUpdate

     while @@fetch_status=    --循环读取

     begin

     -- print @noToUpdate

       -- print GETDATE()

      set @strsql = 'delete from test.dbo.abc1_'+@noToUpdate+' where endtime< GETDATE()';

      print @strsql

      execute(@strsql)

      fetch next from kindcollection into @noToUpdate

      end

      close kindcollection    --关闭

       deallocate kindcollection    --删除

END