http://www.sqle.ru/index.php?action=history&feed=atom&title=SQL_Server%2FT-SQL%2FString_Functions%2FRIGHT
SQL Server/T-SQL/String Functions/RIGHT - История изменений
2026-05-24T22:19:19Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://www.sqle.ru/index.php?title=SQL_Server/T-SQL/String_Functions/RIGHT&diff=5588&oldid=prev
в 13:46, 26 мая 2010
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/RIGHT&diff=5589&oldid=prev
Admin: 1 версия
2010-05-26T10:19:53Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Get string to the right==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
25><br />
26> IF EXISTS(SELECT name FROM sys.tables<br />
27> WHERE name = "T")<br />
28> DROP TABLE T<br />
29> GO<br />
1><br />
2> CREATE TABLE T (<br />
3> c1 int,<br />
4> c2 varchar(8000)<br />
5> )<br />
6> GO<br />
1><br />
2> DECLARE @v1 varchar(max)<br />
3><br />
4> SET @v1 = REPLICATE("A",7999) + "B"<br />
5> INSERT T VALUES (1, @v1)<br />
6> SELECT RIGHT(c2,2) "Right 2 of c2" FROM T<br />
7><br />
8> SET @v1 = @v1 + "B"<br />
9> INSERT T VALUES (2, @v1)<br />
10> SELECT RIGHT(c2,2) "Right 2 of c2" FROM T<br />
11> GO<br />
(1 rows affected)<br />
Right 2 of c2<br />
-------------<br />
AB<br />
Msg 8152, Level 16, State 10, Server sqle\SQLEXPRESS, Line 9<br />
String or binary data would be truncated.<br />
The statement has been terminated.<br />
(1 rows affected)<br />
Right 2 of c2<br />
-------------<br />
AB<br />
(1 rows affected)<br />
1><br />
2> drop table t<br />
3> GO<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==RIGHT: return a number of characters from the right-hand side of a string==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
1> -- RIGHT: return a number of characters from the right-hand side of a string.<br />
2><br />
3> DECLARE @RIGHT_STRING char(100)<br />
4> SET @RIGHT_STRING = "www.sqle.ru"<br />
5><br />
6> SELECT RIGHT(@RIGHT_STRING,10)<br />
7> GO<br />
----------<br />
<br />
(1 rows affected)<br />
1><br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==RIGHT(@RIGHT_STRING,10)==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
1> -- This produces a result of ten spaces, because the last 10 characters are <br />
space filled.<br />
2><br />
3> DECLARE @RIGHT_STRING varchar(100)<br />
4> SET @RIGHT_STRING = "www.sqle.ru"<br />
5><br />
6> SELECT RIGHT(@RIGHT_STRING,10)<br />
7> GO<br />
----------<br />
sqle.ru<br />
(1 rows affected)<br />
1><br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==RIGHT(): starts at the right-most character and counts to the left, returning the specified number of characters==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
1><br />
2> -- RIGHT(): starts at the right-most character and counts to the left, returning the<br />
3> -- specified number of characters.<br />
4><br />
5><br />
6> DECLARE @FullName VarChar(25)<br />
7> SET @FullName = "George Washington"<br />
8> SELECT RIGHT(@FullName, 5)<br />
9><br />
10> GO<br />
-----<br />
ngton<br />
(1 rows affected)<br />
1><br />
<br />
</source></div>
Admin