
复制Declare @idx int,查询查询查询
@idxCount int,@MbCd varchar(20) Set @idxCount = 0 Declare Cur_Test Cursor For Select M.MB_CD From Order O Inner Join Member M On O.MB_CD=M.MB_CD Open Cur_Test Fetch Next From Cur_Test Into @MbCd While (@@FETCH_STATUS = 0) Begin Set @idx = 1 Set @idxCount = @idxCount + @idx Fetch Next From Cur_Test Into @MbCd End Close Cur_Test DEALLOCATE Cur_Test print @idxCount 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.
(责任编辑:系统运维)