Hidden Formatting Troubles with STR() (SQL Spackle)

Posted on SQL Server Central See other posts from SQL Server Central
Published on Wed, 15 Dec 2010 07:00:00 UT Indexed on 2010/12/17 17:09 UTC
Read the original article Hit count: 522

Filed under:
Fill in another bit of your T-SQL knowledge about STR(). It right justifies, rounds, and controls the output width of columns. Sounds perfect but here's why you might not want to use it.
SQL Backup Join SQL Backup’s 35,000+ customers
to compress and strengthen your backups

"SQL Backup will be a REAL boost to any
DBA lucky enough to use it." Jonathan Allen.
Download a free trial now.

© SQL Server Central or respective owner