游标代码举例

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

1.对低于当前平均价格的书，均提价50%

2对于高于或等于当前平均价格的书，均降价25%

代码如下：

declaretitle_updatecursor

    forselecttitle_id,pricefromtitles

    forupdate

go

局部变量

declare@avg_pricemoney,@title_idtid,@pricemoney

opentitle_update

begintran

计算平均书价

select@avg_price=avg(price)fromtitlesholdlock

fetchtitle_updateinto@title_id,@price

while@@sqlstatus!=2

begin

if @@sqlstatus=1

begin

rollbacktran

raiserror21001"Fetchfailedincursor"

closetitle_update

deallocatecursortitle_update

return

end

if@price<@avg_price

提价50%

updatetitlessetprice=price*$1.50

wherecurrentoftitle_update

else

降价25%

updatetitlessetprice=price*$.75

wherecurrentoftitle_update

if@@error!=0

begin

rollbacktran

raiserror22001"Updatefailed"

closetitle_update

deallocatecursortitle_update

return

end

fetchtitle_updateinto@title_id,@price

end

commit

closetitle_update

deallocatecursortitle_update

go

 

 

 

 

 

 
<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>