用CASE函数来实现,select case len(Field) when 1 then '00'+Field when 2 then '0'+Field when 3 then Field end as NewField from table where conditions长度函数查一下手册
你可以在C#中 用 a.PadLeft(3,'1'); a.PadRight(3,'1')
可以很简单的: right('000'+convert(nvarchar,数字),3)
create FUNCTION [dbo].[ww]( @A NVarchar(3) ) RETURNS NVarchar(3) AS BEGIN IF len(@A)=1 BEGIN SET @A= '00'+@A END IF len(@A)=2 BEGIN SET @A= '0'+@A END RETURN @A ENDSELECT dbo.ww('1')
from table where conditions长度函数查一下手册
a.PadLeft(3,'1');
a.PadRight(3,'1')
right('000'+convert(nvarchar,数字),3)
create FUNCTION [dbo].[ww](
@A NVarchar(3)
)
RETURNS NVarchar(3)
AS
BEGIN
IF len(@A)=1
BEGIN
SET @A= '00'+@A
END
IF len(@A)=2
BEGIN
SET @A= '0'+@A
END
RETURN @A
ENDSELECT dbo.ww('1')