FETCH NEXT FROM是啥意思
1) 计算订单的总额
use NorthWind
GO
DECLARE @each money,@total money
set @total=0
DECLARE totalcur CURSOR
LOCAL SCROLL
FOR
SELECT (UnitPrice*Quantity*(1-Discount)) as each FROM [Order Details]
open totalcur
FETCH NEXT FROM totalcur into @each
WHILE @@FETCH_STATUS=0
BEGIN
set @total=@total+@each
FETCH NEXT FROM totalcur into @each
END
CLOSE totalcur
DEALLOCATE totalcur
print @total
GO