http://www.sqle.ru/index.php?action=history&feed=atom&title=SQL_Server%2FT-SQL%2FString_Functions%2FEscape 2026-05-24T04:02:28Z История изменений этой страницы в вики MediaWiki 1.30.0 http://www.sqle.ru/index.php?title=SQL_Server/T-SQL/String_Functions/Escape&diff=5560&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://www.sqle.ru/index.php?title=SQL_Server/T-SQL/String_Functions/Escape&diff=5561&oldid=prev 2010-05-26T10:19:50Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>==Like with escape==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> <br /> 1&gt; CREATE TABLE project (project_no CHAR(4) NOT NULL,<br /> 2&gt; project_name CHAR(15) NOT NULL,<br /> 3&gt; budget FLOAT NULL)<br /> 4&gt; GO<br /> 1&gt; insert into project values (&quot;p1&quot;, &quot;Search Engine&quot;, 120000.00)<br /> 2&gt; insert into project values (&quot;p2&quot;, &quot;Programming&quot;, 95000.00)<br /> 3&gt; insert into project values (&quot;p3&quot;, &quot;SQL&quot;, 186500.00)<br /> 4&gt; GO<br /> (1 rows affected)<br /> (1 rows affected)<br /> (1 rows affected)<br /> 1&gt;<br /> 2&gt; SELECT project_no, project_name<br /> 3&gt; FROM project<br /> 4&gt; WHERE project_name LIKE &quot;%!_%&quot; ESCAPE &quot;!&quot;<br /> 5&gt; GO<br /> project_no project_name<br /> ---------- ---------------<br /> (0 rows affected)<br /> 1&gt; drop table project<br /> 2&gt; GO<br /> <br /> &lt;/source&gt;</div>

Admin