十六进制转换为文件号代码,MSSQL代码库,德仔网

代码语言
代码分类
【MSSQL】十六进制转换为文件号
作者:Dezai.CN / 发布于2011/11/22/ 592
<div>
<h1 class="title_txt"><span style="font-size: 12px; font-weight: normal">------------------------------------------------------</span></h1>
<div class="blogstory">
<p class="MsoNormal" align="left"><span lang="EN-US">--</span><span>功能：十六进制转换为文件号</span><span lang="EN-US"><span> </span></span>
<p class="MsoNormal" align="left"><span lang="EN-US">--</span><span>使用：</span><span lang="EN-US">SELECT dbo.convert_page_nums(0xCF0400000100)<span> </span></span>
<p class="MsoNormal" align="left"><span lang="EN-US">------------------------------------------------------<span> </span></span>
<p class="MsoNormal" align="left"><span lang="EN-US">CREATE</span><span lang="EN-US"><span style="color: rgb(0,0,0)"> </span><span>FUNCTION</span><span style="color: rgb(0,0,0)"> convert_page_nums </span><span>(</span><span style="color: rgb(0,0,0)">@page_num </span><span>binary</span><span>(</span><span style="color: rgb(0,0,0)">6</span><span>))</span></span>
<p class="MsoNormal" align="left"><span lang="EN-US"><span>RETURNS</span><span style="color: rgb(0,0,0)"> </span><span>varchar</span><span>(</span><span style="color: rgb(0,0,0)">11</span><span>)</span></span>
<p class="MsoNormal" align="left">
<p class="MsoNormal" align="left"><span lang="EN-US">AS</span>
<p class="MsoNormal" align="left"><span lang="EN-US"><span>BEGIN</span></span>
<p class="MsoNormal" align="left"><span lang="EN-US"><span>RETURN</span><span>(</span><span>convert</span><span>(</span><span>varchar</span><span>(</span><span style="color: rgb(0,0,0)">2</span><span>),</span><span style="color: rgb(0,0,0)"> </span><span>(</span><span>convert</span><span>(</span><span>int</span><span>,</span><span style="color: rgb(0,0,0)"> </span><span>substring</span><span>(</span><span style="color: rgb(0,0,0)">@page_num</span><span>,</span><span style="color: rgb(0,0,0)"> 6</span><span>,</span><span style="color: rgb(0,0,0)"> 1</span><span>))</span></span>
<p class="MsoNormal" align="left"><span lang="EN-US"><span>*</span><span style="color: rgb(0,0,0)"> </span><span>power</span><span>(</span><span style="color: rgb(0,0,0)">2</span><span>,</span><span style="color: rgb(0,0,0)"> 8</span><span>))</span><span style="color: rgb(0,0,0)"> </span><span>+</span></span>
<p class="MsoNormal" align="left"><span lang="EN-US"><span>(</span><span>convert</span><span>(</span><span>int</span><span>,</span><span style="color: rgb(0,0,0)"> </span><span>substring</span><span>(</span><span style="color: rgb(0,0,0)">@page_num</span><span>,</span><span style="color: rgb(0,0,0)"> 5</span><span>,</span><span style="color: rgb(0,0,0)"> 1</span><span>))))</span><span style="color: rgb(0,0,0)"> </span><span>+</span><span style="color: rgb(0,0,0)"> </span><span>':'</span><span style="color: rgb(0,0,0)"> </span><span>+</span></span>
<p class="MsoNormal" align="left"><span lang="EN-US"><span>convert</span><span>(</span><span>varchar</span><span>(</span><span style="color: rgb(0,0,0)">11</span><span>),</span></span>
<p class="MsoNormal" align="left"><span lang="EN-US"><span>(</span><span>convert</span><span>(</span><span>int</span><span>,</span><span style="color: rgb(0,0,0)"> </span><span>substring</span><span>(</span><span style="color: rgb(0,0,0)">@page_num</span><span>,</span><span style="color: rgb(0,0,0)"> 4</span><span>,</span><span style="color: rgb(0,0,0)"> 1</span><span>))</span><span style="color: rgb(0,0,0)"> </span><span>*</span><span style="color: rgb(0,0,0)"> </span><span>power</span><span>(</span><span style="color: rgb(0,0,0)">2</span><span>,</span><span style="color: rgb(0,0,0)"> 24</span><span>))</span><span style="color: rgb(0,0,0)"> </span><span>+</span></span>
<p class="MsoNormal" align="left"><span lang="EN-US"><span>(</span><span>convert</span><span>(</span><span>int</span><span>,</span><span style="color: rgb(0,0,0)"> </span><span>substring</span><span>(</span><span style="color: rgb(0,0,0)">@page_num</span><span>,</span><span style="color: rgb(0,0,0)"> 3</span><span>,</span><span style="color: rgb(0,0,0)"> 1</span><span>))</span><span style="color: rgb(0,0,0)"> </span><span>*</span><span style="color: rgb(0,0,0)"> </span><span>power</span><span>(</span><span style="color: rgb(0,0,0)">2</span><span>,</span><span style="color: rgb(0,0,0)"> 16</span><span>))</span><span style="color: rgb(0,0,0)"> </span><span>+</span></span>
<p class="MsoNormal" align="left"><span lang="EN-US"><span>(</span><span>convert</span><span>(</span><span>int</span><span>,</span><span style="color: rgb(0,0,0)"> </span><span>substring</span><span>(</span><span style="color: rgb(0,0,0)">@page_num</span><span>,</span><span style="color: rgb(0,0,0)"> 2</span><span>,</span><span style="color: rgb(0,0,0)"> 1</span><span>))</span><span style="color: rgb(0,0,0)"> </span><span>*</span><span style="color: rgb(0,0,0)"> </span><span>power</span><span>(</span><span style="color: rgb(0,0,0)">2</span><span>,</span><span style="color: rgb(0,0,0)"> 8</span><span>))</span><span style="color: rgb(0,0,0)"> </span><span>+</span></span>
<p class="MsoNormal" align="left"><span lang="EN-US"><span>(</span><span>convert</span><span>(</span><span>int</span><span>,</span><span style="color: rgb(0,0,0)"> </span><span>substring</span><span>(</span><span style="color: rgb(0,0,0)">@page_num</span><span>,</span><span style="color: rgb(0,0,0)"> 1</span><span>,</span><span style="color: rgb(0,0,0)"> 1</span><span>))))</span><span style="color: rgb(0,0,0)"> </span><span>)</span></span>
<p class="MsoNormal" align="left"><span lang="EN-US"><span>END</span></span>
<p class="MsoNormal" align="left">
</div>
</div>
试试其它关键字
同语言下
可能有用的
Dezai.CN贡献的其它代码(4037)