use testtest
-- 定义游标MyTestCursor:
declare MyTestCursor cursor
for select id,score from returnScore
/*从表中选取两个字段*/
/* 表TBLPRICELISTGROUPITEM中的字段PGI_ITM_CODE是Unique Key */
-- 打开游标MyTestCursor:
open MyTestCursor
declare @id int
declare @score int
--fetch取出游标所指的记录,并将记录结果存入到变量中:
fetch from MyTestCursor into @id,@score
/***************** begin of loop *******************************/
while @@FETCH_STATUS = 0
Begin
update returnScore set score=() where id=@id
fetch next from MyTestCursor into @id,@score
End
/***************** end of loop *******************************/
select @id as code ,@score as price
/***********关闭游标,释放游标:***************/
close MyTestCursor
deallocate MyTestCursor
update returnScore set score=( ?? ) where id=@id --------这一句,,括号里面的是我要分别给id设置的新的分数(已经存在),,,到这里就不会了
广东0420_flb(1171131830) 14:09:27
update returnScore set score=() where id=@id ------------------这一句id会自动轮循,,但是,,我怎么设置,,轮循到的id,,,的对应的score