如何把SELECT记录集中得某个值临时保存到一个变量？
declare @sTermID varchar(20)
declare @nReturn int
declare @nCount int
set @nCount = 1
while @nCount < 41
BEGIN
Set @sTermID = Select top 1 termid from aaa where id=@nCount
Set @nReturn = Select count(termid) from bbb where termid= @sTermID
UPDATE MyTempTable SET use_times = @nReturn where id=@nCount
set @nCount = @nCount + 1
END
这段代码，两个Select句子都有问题：请问怎么修正？？
[解决办法]
declare @sTermID varchar(20)
declare @nReturn int
declare @nCount int
set @nCount = 1
while @nCount < 41
BEGIN
Select top 1 @sTermID =termid from aaa where id=@nCount
Select @nReturn = count(termid) from bbb where termid= @sTermID
UPDATE MyTempTable SET use_times = @nReturn where id=@nCount
set @nCount = @nCount + 1
END
[解决办法]
declare @sTermID varchar(20)
declare @nReturn int
declare @nCount int
set @nCount = 1
while @nCount < 41
BEGIN
Set Select top 1 @sTermID = termid from aaa where id=@nCount
Set Select @nReturn = count(termid) from bbb where termid= @sTermID
UPDATE MyTempTable SET use_times = @nReturn where id=@nCount
set @nCount = @nCount + 1
END
[解决办法]
declare @sTermID varchar(20)
declare @nReturn int
declare @nCount int
set @nCount = 1
while @nCount < 41
BEGIN
Select top 1 @sTermID=termid from aaa where id=@nCount
Select @nReturn=count(termid) from bbb where termid= @sTermID
UPDATE MyTempTable SET use_times = @nReturn where id=@nCount
set @nCount = @nCount + 1
END
[解决办法]
declare @sTermID varchar(20)
declare @nReturn int
declare @nCount int
set @nCount = 1
while @nCount < 41
BEGIN
Set @sTermID =(Select top 1 termid from aaa where id=@nCount)
Set @nReturn =(Select count(termid) from bbb where termid= @sTermID)
UPDATE MyTempTable SET use_times = @nReturn where id=@nCount
set @nCount = @nCount + 1
END
