http://sqle.ru/index.php?action=history&feed=atom&title=SQL_Server%2FT-SQL%2FString_Functions%2FSTR
SQL Server/T-SQL/String Functions/STR - История изменений
2026-04-06T04:55:15Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://sqle.ru/index.php?title=SQL_Server/T-SQL/String_Functions/STR&diff=5586&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://sqle.ru/index.php?title=SQL_Server/T-SQL/String_Functions/STR&diff=5587&oldid=prev
Admin: 1 версия
2010-05-26T10:19:53Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Specifying an overall length greater than the length of the value, decimal point, and the decimal value, the result will be left-padded with spaces==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
1><br />
2> --Specifying an overall length greater than the length of the value, decimal point,<br />
3> --and the decimal value, the result will be left-padded with spaces<br />
4><br />
5> SELECT STR(1, 12, 4)<br />
6> GO<br />
------------<br />
1.0000<br />
(1 rows affected)<br />
1><br />
2><br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==STR(100.325,7)==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
1> --the following will return 100 (note the 4 spaces):<br />
2><br />
3> SELECT STR(100.325,7)<br />
4> GO<br />
-------<br />
100<br />
(1 rows affected)<br />
1><br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==STR(123. 4)==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
1> SELECT STR(123.456789, 8, 4)<br />
2> GO<br />
--------<br />
123.4568<br />
(1 rows affected)<br />
1><br />
2><br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==STR() Function: converts a numeric value to a string==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
1><br />
2> -- STR() Function: converts a numeric value to a string.<br />
3><br />
4> SELECT STR(123.4, 8, 4)<br />
5> GO<br />
--------<br />
123.4000<br />
(1 rows affected)<br />
1><br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==STR() function right-fills the decimal value with zeros==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
1><br />
2> -- STR() function right-fills the decimal value with zeros<br />
3> SELECT STR(1, 6, 4)<br />
4> GO<br />
------<br />
1.0000<br />
(1 rows affected)<br />
1><br />
2><br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==STR: takes a numeric value and changes the data type to a char==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
1> -- STR: takes a numeric value and changes the data type to a char.<br />
2><br />
3> --STR(number_to_convert, length_of_string, [number_of_decimal_places])<br />
4><br />
5> SELECT STR(100.325,7,2)<br />
6> GO<br />
-------<br />
100.33<br />
(1 rows affected)<br />
1><br />
<br />
</source></div>
Admin