Sqlserver 存储过程

1、功能描述: 有一个名叫OGG_EVENT的表，里面有个一段event_txt里面记录了ddl操作的文本，我们需要用一个存储过程来执行里面的ddl, 然后将EVENT_IMP设置为‘Y',表示已经执行了

OGG_EVNT表的定义

存储过程的概要

存储过程的内容:

USE [TestDB]
GO
/****** Object:  StoredProcedure [dbo].[execAllOGGDDL]    Script Date: 09/30/2015 14:45:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[execAllOGGDDL]


AS
BEGIN
  DECLARE @EVT_ID VARCHAR(10)
  DECLARE @EVT_ITM BIGINT


  DECLARE CUR CURSOR LOCAL FOR
     SELECT EVENT_ID, EVENT_ITM FROM OGG_EVENT WHERE EVENT_IMP='N' and EVENT_TXT <> 'END EVENT' order by EVENT_ID , EVENT_ITM


  --    打开游标
  OPEN CUR
   FETCH NEXT FROM CUR INTO @EVT_ID, @EVT_ITM
   WHILE @@FETCH_STA