34,576
社区成员
发帖
与我相关
我的任务
分享
select replicate('0',10-len(column))+column
declare @i int
set @i='23435'
select right('0000000000'+cast(@i as varchar(10)),10)
结果:0000023435
declare @t table(num varchar(10))
insert @t select '123'
insert @t select 'ad'
insert @t select '456'
select cast(num as int) from @t where isnumeric(num)=1
/*
-----------
123
456
(所影响的行数为 2 行)*/
declare @i int
set @i='23435'
select cast(@i as varchar(10))
23435
cast('inttype' as varchar(10))