在DB中存储变量以便以后调用

本文介绍了在DB中存储变量以便以后调用的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

大家好，我有一个看起来有点棘手的人。我想要做的是计算我的累积BTU测量值。我已经在数据库中存储了各种信息，我可以计算BTU / Hr的产量。计算累积BTU的公式如下（每分钟）：

Hello folks, I''ve got one that seems a little tricky to me. What I want to do is to calculate my cumulative BTU measurements. I''m already storing various information in the database where I can calculate the BTU/Hr production. The formula to calculate Cumulative BTUs is as follows (per minute):

展开 | 选择 | Wrap | 行号 推荐答案

你用什么作为前端？ 你能在那里进行计算吗？ What are you using as a front end? Can you do the calculations in there?

实际上我在调用存储过程时想出了算法。我现在遇到的问题是尝试处理NULL值。这是它挂起的代码块： Actually I figured out the algorithm when I call my stored procedure. The problem I have now is trying to handle a NULL value. This is the block of code that its hanging up on: 展开 | 选择 | Wrap | 行号

Comprisons在包含NULL的地方掉落。 要测试NULL值，请使用IS NULL Comprisons fall down where NULL is involved. To test for a NULL value use IS NULL