新手求助

[omarchen]

有2个字段id和title,id如为CS12138,title则为[CS12138]xxxxx,由于一些问题title中的值变成了[CS22138]xxxxx(或其他值),我想让title中的[ ]里的值与id中一致应该如何解决?

[year2005]

update tablename
set title='['+id+']'+substring(title,charindex(']',title)+1,8000)

[venket]

create table #ke
(id char(20) primary key ,title char (300))

insert into #ke
select '1a','a'
union
select '1b','b'
union
select 1,3
union
select 2,4
union
select 3,'a'

select id,'['+rtrim(id)+']'+title as title from #ke

[omarchen]

要在原表中修改

[omarchen]

up一下

[omarchen]

再up