select left(OldValue,charindex(OldValue,',')-1) as OldValue, right(OldValue,len(OldValue)-charindex(OldValue,',')+1) as NewValue from auditlog where entryid = 39188
不好意思,出错了. vivianfdlpw() 说的对.
create table auditlog (entryid int,OldValue varchar(20)) insert into auditlog select 39188,'AAA,BBB' select left(a.OldValue,charindex(',',a.oldvalue)-1) oldvalues ,right(a.OldValue,charindex(',',a.oldvalue)-1)from (select * from auditlog where entryid = 39188) adrop table auditlog go
手快有 手慢无 55555vivianfdlpw()你也太快了吧 你让我怎么过啊
楼主描述问题是否:逗号隔开分别前面为OldValue,后面为NewValueselect left(OldValue,charindex(',', OldValue) - 1 ) as OldValue, right(OldValue,len(OldValue) - charindex(',', OldValue) ) as NewValue from auditlog where entryid = 39188 这样即使是aaaa,bbbb也是可以~
insert @tb select 'AAA,BBB'
select [OldValue]=left(OldValue,charindex(',',OldValue)-1),
[NewValue]=right(oldValue,len(OldValue)-charindex(',',OldValue))
from @tb--结果
/*
OldValue NewValue
---------- ----------
AAA BBB(所影响的行数为 1 行)
*/
right(OldValue,len(OldValue)-charindex(OldValue,',')+1) as NewValue
from auditlog where entryid = 39188
(entryid int,OldValue varchar(20))
insert into auditlog
select 39188,'AAA,BBB'
select left(a.OldValue,charindex(',',a.oldvalue)-1) oldvalues ,right(a.OldValue,charindex(',',a.oldvalue)-1)from (select * from auditlog where entryid = 39188) adrop table auditlog
go
55555vivianfdlpw()你也太快了吧
你让我怎么过啊
right(OldValue,len(OldValue) - charindex(',', OldValue) ) as NewValue
from auditlog where entryid = 39188 这样即使是aaaa,bbbb也是可以~