1. There’s a
table with below data.
![](http://1.bp.blogspot.com/-SZ_j80yRN_s/UzMP6t6KwOI/AAAAAAAABVo/kx3mx7cAFHY/s1600/2.PNG)
Query:
declare @employee as table(
id int
)
insert into @employee values(1)
insert into @employee values(20)
insert into @employee values(300)
insert into @employee values(4000)
insert into @employee values(50000)
insert into @employee values(600000)
select * from @employee
select replicate('0',6-len(id)) + cast(id as varchar) from @employee
Query:
declare @employee as table(
id int
)
insert into @employee values(1)
insert into @employee values(20)
insert into @employee values(300)
insert into @employee values(4000)
insert into @employee values(50000)
insert into @employee values(600000)
select * from @employee
select replicate('0',6-len(id)) + cast(id as varchar) from @employee
No comments:
Post a Comment