在DB中存储变量以便以后调用 [英] Storing variables in DB for later recall

问题描述

大家好，我有一个看起来有点棘手的人。我想要做的是计算我的累积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

这篇关于在DB中存储变量以便以后调用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！