http://sqle.ru/index.php?action=history&feed=atom&title=SQL_Server%2FT-SQL%2FString_Functions%2FCHAR 2026-04-06T04:55:14Z История изменений этой страницы в вики MediaWiki 1.30.0 http://sqle.ru/index.php?title=SQL_Server/T-SQL/String_Functions/CHAR&diff=5572&oldid=prev 2010-05-26T13:46:06Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <tr style="vertical-align: top;" lang="ru"> <td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td> <td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:46, 26 мая 2010</td> </tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div> </td></tr></table>

http://sqle.ru/index.php?title=SQL_Server/T-SQL/String_Functions/CHAR&diff=5573&oldid=prev 2010-05-26T10:19:51Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>==CHAR(65): 65 is A==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> <br /> 1&gt;<br /> 2&gt; SELECT CHAR(65)<br /> 3&gt; GO<br /> -<br /> A<br /> (1 rows affected)<br /> 1&gt;<br /> <br /> &lt;/source&gt;<br /> <br /> <br /> <br /> <br /> ==CHAR(CAST(0x3A as int))==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> <br /> 1&gt; SELECT CHAR(CAST(0x43 as int)) + CHAR(CAST(0x3A as int)) +<br /> 2&gt; CHAR(CAST(0x5C as int)) + CHAR(CAST(0x50 as int)) + CHAR(CAST(0x72 as int))<br /> 3&gt; + CHAR(CAST(0x6F as int)) + CHAR(CAST(0x67 as int))<br /> 4&gt; + CHAR(CAST(0x72 as int)) + CHAR(CAST(0x61 as int))<br /> 5&gt; + CHAR(CAST(0x6D as int)) + CHAR(CAST(0x20 as int))<br /> 6&gt;<br /> 7&gt; GO<br /> -----------<br /> C:\Program<br /> (1 rows affected)<br /> 1&gt;<br /> <br /> &lt;/source&gt;<br /> <br /> <br /> <br /> <br /> ==CHAR: the reverse of the ASCII function as it changes a numeric value in to an ASCII character==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> 1&gt; --CHAR: the reverse of the ASCII function as it changes a numeric value in to an ASCII character.<br /> 2&gt;<br /> 3&gt; DECLARE @ASCII_VALUE INT<br /> 4&gt; SET @ASCII_VALUE = 82<br /> 5&gt; SELECT CHAR(@ASCII_VALUE)<br /> 6&gt;<br /> 7&gt; GO<br /> -<br /> R<br /> (1 rows affected)<br /> 1&gt;<br /> <br /> &lt;/source&gt;</div>

Admin