触发器和存储过程

USE [ALM]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[PROC_SYNCH_IRREG_SOFTLIST]
AS
BEGIN
    DECLARE @k NVARCHAR(255)
    DECLARE @j NVARCHAR(255)
    DECLARE @i int
    DECLARE cursor_repair_rec CURSOR FOR
    select @i=ziduan1,@j=ziduan2,@k=ziduan3
              from
             table
    OPEN cursor_repair_rec
    FETCH NEXT FROM cursor_repair_rec INTO @i,@j,@k
WHILE @@FETCH_STATUS=0
BEGIN 
  
    insert into obj(XX1,xx2,xx3)
     values(@i,@j,@k);         
  FETCH NEXT FROM cursor_repair_rec INTO @i,@j,@k
END
CLOSE cursor_repair_rec
DEALLOCATE cursor_repair_rec        
   
END