定义并声明了游标... ...
open lxCursor
Fetch FIRST from lxCursor into @wzmc,@dwmc,@qylx
while (@@Fetch_status=0)
Begin
if @qylx is not NULL then
@result_multiply=@reulst_multiply*@qylx;
@result_sum=@result_sum+@qylx
end if
Fetch NEXT from lxCursor into @wzmc,@dwmc,@qylx
End
close lxCursor
......这段代码if语句报错,不知道什么原因“关键字 'then' 附近有语法错误。”大家帮我看看!先谢谢了!
open lxCursor
Fetch FIRST from lxCursor into @wzmc,@dwmc,@qylx
while (@@Fetch_status=0)
Begin
if @qylx is not NULL then
@result_multiply=@reulst_multiply*@qylx;
@result_sum=@result_sum+@qylx
end if
Fetch NEXT from lxCursor into @wzmc,@dwmc,@qylx
End
close lxCursor
......这段代码if语句报错,不知道什么原因“关键字 'then' 附近有语法错误。”大家帮我看看!先谢谢了!
set @result_sum=@result_sum+@qylx
if (...)
begin
--...
end
[
ELSE
{ sql_statement | statement_block } ]
open lxCursor
Fetch FIRST from lxCursor into @wzmc,@dwmc,@qylx
while (@@Fetch_status=0)
Begin
if @qylx is not NULL
begin
set @result_multiply=@result_multiply*@qylx
set @result_sum=@result_sum+@qylx
end
Fetch NEXT from lxCursor into @wzmc,@dwmc,@qylx
End
close lxCursor