存储过程排序功能,带返回值代码,MSSQL代码库,德仔网

代码语言

代码分类

【MSSQL】存储过程排序功能,带返回值

作者:Dezai.CN / 发布于2011/11/22/ 672

<div>
<div><span style="color: #0000ff">create</span><span style="color: #000000"> </span><span style="color: #0000ff">proc</span><span style="color: #000000"> proc_grade(
</span><span style="color: #008000">@testname</span><span style="color: #000000"> </span><span style="color: #0000ff">varchar</span><span style="color: #000000">(</span><span style="color: #800000; font-weight: bold">50</span><span style="color: #000000">),
</span><span style="color: #008000">@grade</span><span style="color: #000000"> </span><span style="color: #0000ff">int</span><span style="color: #000000"> output)
</span><span style="color: #0000ff">as</span><span style="color: #000000">
</span><span style="color: #0000ff">begin</span><span style="color: #000000">
</span><span style="color: #0000ff">select</span><span style="color: #000000"> </span><span style="color: #008000">@grade</span><span style="color: #808080">=</span><span style="color: #000000">mingci </span><span style="color: #0000ff">from</span><span style="color: #000000"> ( </span><span style="color: #0000ff">select</span><span style="color: #000000"> row_number() </span><span style="color: #0000ff">over</span><span style="color: #000000"> (</span><span style="color: #0000ff">order</span><span style="color: #000000"> </span><span style="color: #0000ff">by</span><span style="color: #000000"> score </span><span style="color: #0000ff">desc</span><span style="color: #000000">) </span><span style="color: #0000ff">as</span><span style="color: #000000"> mingci ,score,testname </span><span style="color: #0000ff">from</span><span style="color: #000000"> scoreinfo ) </span><span style="color: #0000ff">as</span><span style="color: #000000"> a </span><span style="color: #0000ff">where</span><span style="color: #000000"> a.testname </span><span style="color: #808080">=</span><span style="color: #000000"> </span><span style="color: #008000">@testname</span><span style="color: #000000">
</span><span style="color: #0000ff">end</span><span style="color: #000000">


</span><span style="color: #0000ff">select</span><span style="color: #000000"> row_number() </span><span style="color: #0000ff">over</span><span style="color: #000000"> (</span><span style="color: #0000ff">order</span><span style="color: #000000"> </span><span style="color: #0000ff">by</span><span style="color: #000000"> score </span><span style="color: #0000ff">desc</span><span style="color: #000000">) </span><span style="color: #0000ff">as</span><span style="color: #000000"> mingci ,score,testname </span><span style="color: #0000ff">from</span><span style="color: #000000"> scoreinfo
</span><span style="color: #0000ff">declare</span><span style="color: #000000"> </span><span style="color: #008000">@grade</span><span style="color: #000000"> </span><span style="color: #0000ff">varchar</span><span style="color: #000000">(</span><span style="color: #800000; font-weight: bold">50</span><span style="color: #000000">)
</span><span style="color: #0000ff">exec</span><span style="color: #000000"> proc_grade </span><span style="color: #ff0000">'</span><span style="color: #ff0000">kdk</span><span style="color: #ff0000">'</span><span style="color: #000000">, </span><span style="color: #008000">@grade</span><span style="color: #000000"> output
</span><span style="color: #0000ff">print</span><span style="color: #000000"> </span><span style="color: #008000">@grade</span></div>
</div>

评论列表

本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。

试试其它关键字

　存储过程排序功能,带返回值　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)