UPDATE tb SET name = LEFT(name,LEN(name)-1) WHERE RIGHT(name,1)=';'
UPDATE tb set name = stuff(name,len(name),1,'') where right(name,1)=';'
UPDATE tb set name = stuff(name,len(name),1,'') where name like '%;'
update student set subject=replace(subject,';','') where charindex(';',subject)>0
if object_id('[tb7]') is not null drop table [tb7] create table [tb7] ( id int not null, [name] varchar(25) ) insert [tb7] select 1,'piao;' union all select 2,'聊天' union all select 3,'咳咳;' go --第一种写法 update tb7 set [name]=left([name],len([name])-1) where right([name],1)=';' select * from tb7 --第二种写法 update tb7 set [name]=stuff([name],len([name]),0,'') from [tb7] where right([name],1)=';'--删除环境 drop table [tb7]
name = LEFT(name,LEN(name)-1)
WHERE RIGHT(name,1)=';'
UPDATE tb set name = stuff(name,len(name),1,'') where right(name,1)=';'
update student set subject=replace(subject,';','') where charindex(';',subject)>0
create table [tb7]
(
id int not null,
[name] varchar(25)
)
insert [tb7]
select 1,'piao;' union all
select 2,'聊天' union all
select 3,'咳咳;'
go
--第一种写法
update tb7 set
[name]=left([name],len([name])-1)
where right([name],1)=';'
select * from tb7
--第二种写法
update tb7 set
[name]=stuff([name],len([name]),0,'') from [tb7]
where right([name],1)=';'--删除环境
drop table [tb7]