一条比较SQL代码,MSSQL代码库,德仔网

代码语言

代码分类

【MSSQL】一条比较SQL

作者:罪恶的花生 / 发布于2011/1/10/ 632

如果是正偏，显示为"+",如果是负偏向显示”-“，如果没有则显示”-“，该语句MSSQLserver2000下测试通过

<table>
    <tbody>
        <tr>
            <td class="content">"sql comments">--hjc为记录条数，如果没有记录则没有可比性。否则显示比较值 </td>
        </tr>
    </tbody>
</table>
<div class="line alt2">
<table>
    <tbody>
        <tr>
            <td class="number">2</td>
            <td class="content">"sql color2">case "sql keyword">when "sql plain">hjc=0 "sql keyword">then "sql string">'-' "sql keyword">else "sql color2">CAST"sql plain">("sql color2">case "sql keyword">when "sql plain">(hj-hjc)>0 "sql keyword">then "sql string">'+'"sql plain">+"sql color2">cast"sql plain">((hj-hjc) "sql keyword">as "sql keyword">varchar"sql plain">) "sql keyword">else "sql color2">cast"sql plain">((hj-hjc) "sql keyword">as "sql keyword">varchar"sql plain">) "sql keyword">end "sql keyword">as "sql keyword">varchar"sql plain">(5000)) "sql keyword">end "sql keyword">as "sql plain">hj2, </td>
        </tr>
    </tbody>
</table>
</div>
<div class="line alt1">
<table>
    <tbody>
        <tr>
            <td class="number">3</td>
            <td class="content">"sql color2">case "sql keyword">when "sql plain">hjc=0 "sql keyword">then "sql string">'-'"sql keyword">else "sql color2">CAST"sql plain">("sql color2">CAST"sql plain">("sql color2">CASE "sql keyword">WHEN "sql plain">wfhjc =wfhj "sql keyword">THEN "sql plain">0 "sql keyword">WHEN "sql plain">wfhjc = 0 "sql color1">AND "sql plain">wfhj>0 "sql keyword">THEN "sql plain">100 "sql keyword">ELSE "sql plain">(wfhj-wfhjc) * 100.0 / wfhjc "sql keyword">END "sql keyword">AS "sql keyword">DECIMAL"sql plain">(10,2)) "sql keyword">as "sql keyword">varchar"sql plain">(5000)) "sql keyword">end "sql keyword">as "sql plain">wfl2,</td>
        </tr>
    </tbody>
</table>
</div>

试试其它关键字

　比较SQL　

同语言下

可能有用的

罪恶的花生贡献的其它代码(13)