22,209
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE ballance
AS
declare @MatchScore varchar(6)
declare @MatchLetFlag tinyint
declare @SaleId int
declare @SalePkType varchar(20)
declare @SaleSelect tinyint
declare @SalePK varchar(50)
declare @SaleSureMoney money
BEGIN
DECLARE Sale_cursor CURSOR FOR
SELECT m.MatchScore,m.MatchLetFlag,s.SaleId,s.SalePkType,s.SaleSelect,s.SalePK,s.SaleSureMoney FROM TM_match m ,TM_Sale s
where m.MatchId = s.MatchId and s.SaleResult ='a'
open Sale_cursor
fetch next from Sale_cursor into
@MatchScore,@MatchLetFlag,@SaleId,@SalePkType,@SaleSelect,@SalePK,@SaleSureMoney
while (@@fetch_status=0)
begin
print @MatchScore
fetch next from Sale_cursor into
@MatchScore,@MatchLetFlag,@SaleId,@SalePkType,@SaleSelect,@SalePK,@SaleSureMoney
end
close Sale_cursor
END
GO
CREATE PROCEDURE ballance
AS
declare @MatchScore varchar(6)
declare @MatchLetFlag tinyint
declare @SaleId int
declare @SalePkType varchar(20)
declare @SaleSelect tinyint
declare @SalePK varchar(50)
declare @SaleSureMoney money
BEGIN
DECLARE Sale_cursor CURSOR FOR
select m.MatchScore,m.MatchLetFlag,s.SaleId,s.SalePkType,s.SaleSelect,s.SalePK,s.SaleSureMoney --前面一个全角的空格
from TM_match m,TM_Sale s
where m.MatchId = s.MatchId and s.SaleResult = 'a'
open Sale_cursor
fetch next from Sale_cursor into @MatchScore,@MatchLetFlag,@SaleId,@SalePkType,@SaleSelect,@SalePK,@SaleSureMoney
while (@@fetch_status=0)
begin
print @MatchScore
fetch next from Sale_cursor into @MatchScore,@MatchLetFlag,@SaleId,@SalePkType,@SaleSelect,@SalePK,@SaleSureMoney
end
close Sale_cursor
END
GO