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
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