Str() 与 Cast() 和 Convert() 的区别

str() 可以对右边进行调整，允许设定小数的位置

 

例：

 

select str(123,10) as str, cast(123 as char(10)) as cast

 

str   cast

------------

123  123

 

select str(PI(),7,4) as str, cast(PI() as char(7) as Cast

 

 

str          cast

-----------------

3.1416   4.15159