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

代码语言
代码分类
【MSSQL】存储过程排序功能,带返回值
作者:Dezai.CN / 发布于2011/11/22/ 771
<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)