http://sqle.ru/index.php?action=history&feed=atom&title=SQL_Server%2FT-SQL%2FSystem%2FsysmessagesSQL Server/T-SQL/System/sysmessages - История изменений2026-04-06T12:10:12ZИстория изменений этой страницы в викиMediaWiki 1.30.0http://sqle.ru/index.php?title=SQL_Server/T-SQL/System/sysmessages&diff=5854&oldid=prev в 13:46, 26 мая 20102010-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/System/sysmessages&diff=5855&oldid=prevAdmin: 1 версия2010-05-26T10:20:34Z<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Retrieve additional error information: sysmessages table==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
1> -- Retrieve additional error information: sysmessages table<br />
2><br />
3><br />
4> SELECT 5 / 0<br />
5> SELECT * FROM master.dbo.sysmessages WHERE error = @@ERROR<br />
6> GO<br />
Msg 8134, Level 16, State 1, Server sqle\SQLEXPRESS, Line 4<br />
Divide by zero error encountered.<br />
error severity dlevel description<br />
msglangid<br />
----------- -------- ------ ----------------------------------------------------------------------------------------<br />
------------------------------------------------------------------------------------------------------- ---------<br />
8134 16 0 Divide by zero error encountered.<br />
1033<br />
(1 rows affected)<br />
1><br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==SELECT TOP 10 * FROM master.dbo.sysmessages==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
1> -- @@ERROR: contains the last error number for the current connection.<br />
2> -- The default value for @@ERROR is zero.<br />
3><br />
4> SELECT TOP 10 * FROM master.dbo.sysmessages<br />
5><br />
6> GO<br />
error severity dlevel description<br />
msglangid<br />
----------- -------- ------ --------------------------------------------------------------------------------------------------------------------------------------------------------<br />
------------------------------------------------------------------------------------------------------- ---------<br />
21 20 0 Warning: Fatal error %d occurred at %S_DATE. Note the error and time, and contact your system administrator.<br />
1033<br />
101 15 0 Query not allowed in WAITFOR.<br />
1033<br />
102 15 0 Incorrect syntax near "%.*ls".<br />
1033<br />
103 15 0 The %S_MSG that starts with "%.*ls" is too long. Maximum length is %d.<br />
1033<br />
104 15 0 ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operator.<br />
1033<br />
105 15 0 Unclosed quotation mark after the character string "%.*ls".<br />
1033<br />
106 16 0 Too many table names in the query. The maximum allowable is %d.<br />
1033<br />
107 15 0 The column prefix "%.*ls" does not match with a table name or alias name used in the query.<br />
1033<br />
108 15 0 The ORDER BY position number %ld is out of range of the number of items in the select list.<br />
1033<br />
109 15 0 There are more columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the numb<br />
er of columns specified in the INSERT statement. 1033<br />
(10 rows affected)<br />
1><br />
<br />
</source></div>Admin