34,838
社区成员




create table [ACTION]
(ACTION_ID varchar(10),[ACTION] varchar(20), USERS varchar(10),[DATE] datetime)
insert [action] select
'001','登录工作站 <200a>','陈明','2008-02-23 10:00:00' union select
'001','删除文件030303','陈明','2008-02-23 10:10:00' union select
'001','退出工作站 <200a>','陈明','2008-02-23 10:45:00' union select
'002','登录工作站 <210a>','张章','2008-02-23 10:20:20' union select
'002','退出工作站 <210a>','张章','2008-02-23 10:40:12'
go
select replace(stuff([action],1,charindex('<',[action]),''),'>','')
from [action]
where charindex('<',[action])> 0
drop table action
/*
--------
200a
200a
210a
210a
(所影响的行数为 4 行)
*/
create table [ACTION]
(ACTION_ID varchar(10),[ACTION] varchar(20), USERS varchar(10),[DATE] datetime)
insert [action] select
'001','登录工作站 <200a>','陈明','2008-02-23 10:00:00' union select
'001','删除文件030303','陈明','2008-02-23 10:10:00' union select
'001','退出工作站 <200a>','陈明','2008-02-23 10:45:00' union select
'002','登录工作站 <210a>','张章','2008-02-23 10:20:20' union select
'002','退出工作站 <210a>','张章','2008-02-23 10:40:12'
go
select left(stuff([action],1,charindex('<',[action]),'') ,4)
from [action]
where charindex('<',[action])> 0
drop table action
/*
--------
200a
200a
210a
210a
(所影响的行数为 4 行)
*/
create table [ACTION]
(ACTION_ID varchar(10),[ACTION] varchar(40), USERS varchar(10),[DATE] datetime)
insert [action] select
'001','登录工作站 <200a>','陈明','2008-02-23 10:00:00' union select
'001','删除文件030303','陈明','2008-02-23 10:10:00' union select
'001','退出工作站 <200a>','陈明','2008-02-23 10:45:00' union select
'002','登录工作站 <210a>','张章','2008-02-23 10:20:20' union select
'002','退出工作站 <210a>','张章','2008-02-23 10:40:12' union select
'003','登录工作站:在 <2106a> 上','李三','2008-02-24 12:45:00'
go
select stuff(stuff([action],charindex('>',[action])-1,100,''),1,charindex('<',[action]),'')
from [action]
where charindex('<',[action])> 0
drop table action
/*
--------
200
200
210
210
2106
(所影响的行数为 5 行)
*/