sorry !
语句是这样的
Declare @TT VARCHAR(100),@Year int,@ii int
Declare cMain_cursor CURSOR FOR
select X from P_A group by X ---------------------------------"有个分组!"
FOR UPDATE OF X
OPEN cMain_cursor
FETCH FROM cMain_cursor
INTO @TT ,@Year
SET @ii = 1
While @@FETCH_STATUS = 0
BEGIN
PRINT CAST(@II AS VARCHAR)+'----'+@TT
update P_BookLits set X = '1'
where CURRENT OF cMain_cursor
SET @ii = @ii + 1
FETCH NEXT FROM cMain_cursor
INTO @TT,@Year
END
CLOSE cMain_cursor
DEALLOCATE cMain_cursor
语句是这样的
Declare @TT VARCHAR(100),@Year int,@ii int
Declare cMain_cursor CURSOR FOR
select X from P_A group by X ---------------------------------"有个分组!"
FOR UPDATE OF X
OPEN cMain_cursor
FETCH FROM cMain_cursor
INTO @TT ,@Year
SET @ii = 1
While @@FETCH_STATUS = 0
BEGIN
PRINT CAST(@II AS VARCHAR)+'----'+@TT
update P_BookLits set X = '1'
where CURRENT OF cMain_cursor
SET @ii = @ii + 1
FETCH NEXT FROM cMain_cursor
INTO @TT,@Year
END
CLOSE cMain_cursor
DEALLOCATE cMain_cursor
高手有没有 什么好办法呀?
对于分组更新 ?