SQL 给字符串补0

               SELECT   STUFF('000000000', 9 - LEN(PTAT.PTAP_Count) + 1,
                              LEN(PTAT.PTAP_Count), PTAT.PTAP_Count)
               FROM     ( SELECT    COUNT(1) AS PTAP_Count
                          FROM      #Detail_PTAP
                        ) AS PTAT;

 

posted @ 2016-02-25 12:19  Sunny Qiang  阅读(393)  评论(0编辑  收藏  举报