SQLServer中查询的数字列前面补0返回指定长度的字符串
时间：2021-07-01 10:21:17
帮助过：3人阅读
***** Script for SelectTopNRows command from SSMS ******/
SELECT TOP 1000 [ID]
,[SN]
,[Name]
FROM [EduDB].[dbo].[TestTab]
select Right(
‘0123456‘,SN)
from TestTab;
select RIGHT(REPLICATE(
‘0‘,
5)+CAST(SN AS varchar(
10)),
5) AS
‘SN‘ from TestTab;
select RIGHT(
‘00000000‘+CAST(SN
as varchar(
10)),
5)
as ‘sn‘ from TestTab
效果如下：
SQLServer中查询的数字列前面补0返回指定长度的字符串
标签：href 查询 pre har 技术分享 lse var strong style
