表结构
TargetDeptCode (Varchar(20)) ，TargetDeptName(Varchar(100))
1,XXXXXXX
2,XXXXXXX
3,XXXXXXX
4,XXXXXXX
....
现在将TargetDeptCode 格式化为
0001
0002
0003
0004
.......
语句如下:
update TargetDepts set TargetDeptCode=right(cast(TargetDeptCode+10000 as varchar(20)),4)
