http://sqle.ru/index.php?action=history&feed=atom&title=SQL_Server%2FT-SQL%2FTransact_SQL%2FStatement 2026-04-06T08:41:33Z История изменений этой страницы в вики MediaWiki 1.30.0 http://sqle.ru/index.php?title=SQL_Server/T-SQL/Transact_SQL/Statement&diff=5720&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/Transact_SQL/Statement&diff=5721&oldid=prev 2010-05-26T10:20:12Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>==Select clause as a statement==<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; CREATE TABLE works_on (emp_no INTEGER NOT NULL,<br /> 3&gt; project_no CHAR(4) NOT NULL,<br /> 4&gt; job CHAR (15) NULL,<br /> 5&gt; enter_date DATETIME NULL)<br /> 6&gt;<br /> 7&gt; insert into works_on values (1, &quot;p1&quot;, &quot;analyst&quot;, &quot;1997.10.1&quot;)<br /> 8&gt; insert into works_on values (1, &quot;p3&quot;, &quot;manager&quot;, &quot;1999.1.1&quot;)<br /> 9&gt; insert into works_on values (2, &quot;p2&quot;, &quot;clerk&quot;, &quot;1998.2.15&quot;)<br /> 10&gt; insert into works_on values (2, &quot;p2&quot;, NULL, &quot;1998.6.1&quot;)<br /> 11&gt; insert into works_on values (3, &quot;p2&quot;, NULL, &quot;1997.12.15&quot;)<br /> 12&gt; insert into works_on values (4, &quot;p3&quot;, &quot;analyst&quot;, &quot;1998.10.15&quot;)<br /> 13&gt; insert into works_on values (5, &quot;p1&quot;, &quot;manager&quot;, &quot;1998.4.15&quot;)<br /> 14&gt; insert into works_on values (6, &quot;p1&quot;, NULL, &quot;1998.8.1&quot;)<br /> 15&gt; insert into works_on values (7, &quot;p2&quot;, &quot;clerk&quot;, &quot;1999.2.1&quot;)<br /> 16&gt; insert into works_on values (8, &quot;p3&quot;, &quot;clerk&quot;, &quot;1997.11.15&quot;)<br /> 17&gt; insert into works_on values (7, &quot;p1&quot;, &quot;clerk&quot;, &quot;1998.1.4&quot;)<br /> 18&gt;<br /> 19&gt; select * from works_on<br /> 20&gt; GO<br /> (1 rows affected)<br /> (1 rows affected)<br /> (1 rows affected)<br /> (1 rows affected)<br /> (1 rows affected)<br /> (1 rows affected)<br /> (1 rows affected)<br /> (1 rows affected)<br /> (1 rows affected)<br /> (1 rows affected)<br /> (1 rows affected)<br /> emp_no project_no job enter_date<br /> ----------- ---------- --------------- -----------------------<br /> 1 p1 analyst 1997-10-01 00:00:00.000<br /> 1 p3 manager 1999-01-01 00:00:00.000<br /> 2 p2 clerk 1998-02-15 00:00:00.000<br /> 2 p2 NULL 1998-06-01 00:00:00.000<br /> 3 p2 NULL 1997-12-15 00:00:00.000<br /> 4 p3 analyst 1998-10-15 00:00:00.000<br /> 5 p1 manager 1998-04-15 00:00:00.000<br /> 6 p1 NULL 1998-08-01 00:00:00.000<br /> 7 p2 clerk 1999-02-01 00:00:00.000<br /> 8 p3 clerk 1997-11-15 00:00:00.000<br /> 7 p1 clerk 1998-01-04 00:00:00.000<br /> (11 rows affected)<br /> 1&gt; -- IF Statement<br /> 2&gt;<br /> 3&gt; IF (SELECT COUNT(*) FROM works_on) &gt; 3<br /> 4&gt; PRINT &quot;The number of employees in the project is 4 or more&quot;<br /> 5&gt; ELSE<br /> 6&gt; PRINT &quot;Less than 4&quot;<br /> 7&gt; GO<br /> The number of employees in the project is 4 or more<br /> 1&gt;<br /> 2&gt; drop table works_on<br /> 3&gt; GO<br /> 1&gt;<br /> 2&gt;<br /> <br /> &lt;/source&gt;</div>

Admin