关于PADLEFT

Create Function PadLeft(@OriginalString varchar(20),@PaddingChar char(1),@TotalLength int)
Returns Varchar(20) As
Begin
    Declare @NewString varchar(20)
    Select @NewString = IsNull(Replicate(@PaddingChar,@TotalLength - Len(isnull(@OriginalString ,0))), '') + @OriginalString
    Return @NewString
End

Create Function PadRight(@OriginalString varchar(20),@PaddingChar char(1),@TotalLength int)
Returns Varchar(20) As
Begin
    Declare @NewString varchar(20)
    Select @NewString = @OriginalString + IsNull(Replicate(@PaddingChar,@TotalLength - Len(isnull(@OriginalString ,0))), '')
    Return @NewString
End

 

 我构造数据给技术部使用的示例

 

 

SELECT TOP 50000
'http://viewres.sj.91.com/site-'
+Cast(SiteID AS varchar)+'(new)/'
+Cast(BookID/1000/1000/100 AS varchar)+'/'
+Cast(BookID/1000 AS varchar)+'/'
+Cast(dbo.PadLeft(SerialNumber, '0', 4) AS varchar)+' '+ChapterName+'.zip' AS '资源下载地址', newid() as '资源大小'

FROM Novel_Chapter_LocalTmp nclt WHERE state=1 AND nclt.ChapterUrl<>''