http://sqle.ru/index.php?action=history&feed=atom&title=SQL_Server%2FT-SQL_Tutorial%2FSystem_Functions%2Fsp_addmessage SQL Server/T-SQL Tutorial/System Functions/sp addmessage - История изменений 2026-04-05T23:58:23Z История изменений этой страницы в вики MediaWiki 1.30.0 http://sqle.ru/index.php?title=SQL_Server/T-SQL_Tutorial/System_Functions/sp_addmessage&diff=6678&oldid=prev в 13:46, 26 мая 2010 2010-05-26T13:46:16Z <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_Tutorial/System_Functions/sp_addmessage&diff=6679&oldid=prev Admin: 1 версия 2010-05-26T10:23:57Z <p>1 версия</p> <p><b>Новая страница</b></p><div>== Adding a custom error==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> 5&gt; EXEC sp_addmessage<br /> 6&gt; @msgnum = 50005,<br /> 7&gt; @severity = 16,<br /> 8&gt; @msgtext = &quot;Problem with ProductIds %i, %i, %i&quot;<br /> 9&gt; GO<br /> Msg 15043, Level 16, State 1, Server J\SQLEXPRESS, Procedure sp_addmessage, Line 137<br /> You must specify &quot;REPLACE&quot; to overwrite an existing message.<br /> 1&gt;<br /> 2&gt;&lt;/source&gt;<br /> <br /> <br /> <br /> == Adding a message to the sysmessages table using the REPLACE option.==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> 3&gt;<br /> 4&gt;<br /> 5&gt; sp_addmessage 50001, 12, &quot;The specified value for %s was invalid.&quot;<br /> 6&gt; , US_English, TRUE, REPLACE<br /> 7&gt; GO&lt;/source&gt;<br /> <br /> <br /> <br /> == Adding Entries to sysmessages==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> 4&gt;<br /> 5&gt; sp_addmessage 50001, 12, &quot;A number greater than 0 was expected. Please retry&quot;<br /> 6&gt; GO&lt;/source&gt;</div> Admin