http://sqle.ru/index.php?action=history&feed=atom&title=SQL_Server%2FT-SQL%2FString_Functions%2FDifference 2026-04-06T04:55:13Z История изменений этой страницы в вики MediaWiki 1.30.0 http://sqle.ru/index.php?title=SQL_Server/T-SQL/String_Functions/Difference&diff=5584&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/Difference&diff=5585&oldid=prev 2010-05-26T10:19:52Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>==DIFFERENCE(): a wrapper around two SOUNDEX() function calls and some business logic to compare the values==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> 1&gt; -- DIFFERENCE(): a wrapper around two SOUNDEX() function calls and some business logic to compare the values.<br /> 2&gt;<br /> 3&gt; -- reducing the result to a scale from 0 to 4, where the value 4 indicates a very close or exact match.<br /> 4&gt;<br /> 5&gt; SELECT DIFFERENCE(&quot;To&quot;, &quot;Two&quot;)<br /> 6&gt;<br /> 7&gt; GO<br /> -----------<br /> 4<br /> (1 rows affected)<br /> 1&gt;<br /> <br /> &lt;/source&gt;<br /> <br /> <br /> <br /> <br /> ==DIFFERENCE: work out when one string sounds similar to another string==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> 1&gt; -- DIFFERENCE: work out when one string sounds similar to another string.<br /> 2&gt;<br /> 3&gt; -- &quot;0&quot; means that the two strings aren&quot;t even close,<br /> 4&gt; -- &quot;4&quot; means a perfect match<br /> 5&gt;<br /> 6&gt; DECLARE @s1 varchar(6)<br /> 7&gt; DECLARE @s2 varchar(6)<br /> 8&gt; SET @s1 = &quot;Dewson&quot;<br /> 9&gt; SET @s2 = &quot;Joosun&quot;<br /> 10&gt;<br /> 11&gt; SELECT DIFFERENCE(@s1,@s2)<br /> 12&gt; GO<br /> -----------<br /> 3<br /> (1 rows affected)<br /> 1&gt;<br /> <br /> &lt;/source&gt;<br /> <br /> <br /> <br /> <br /> ==SELECT DIFFERENCE ( &quot;Fleas&quot;, &quot;Fleece&quot;)==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> <br /> 4&gt;<br /> 5&gt; SELECT DIFFERENCE ( &quot;Fleas&quot;, &quot;Fleece&quot;)<br /> 6&gt; GO<br /> -----------<br /> 3<br /> (1 rows affected)<br /> 1&gt;<br /> 2&gt;<br /> &lt;/source&gt;<br /> <br /> <br /> <br /> <br /> ==Using the DIFFERENCE() function to compare Redmond with Renton==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> <br /> 1&gt; -- Using the DIFFERENCE() function to compare Redmond with Renton<br /> 2&gt;<br /> 3&gt; SELECT DIFFERENCE (&quot;Redmond&quot;, &quot;Renton&quot;)<br /> 4&gt; GO<br /> -----------<br /> 3<br /> (1 rows affected)<br /> 1&gt;<br /> <br /> &lt;/source&gt;</div>

Admin