--2006年 3月6日 sql server 替换语句。
---建立表
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TABLE1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TABLE1]
GO
CREATE TABLE [dbo].[TABLE1] (
[a] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[b] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
insert table1 values('D:/eclipse-SDK-3.0.1-win32/eclipse','aaa');
insert table1 values('D:/eclipse-SDK-3.2.1-win32/eclipse','aaa');
insert table1 values('D:/eclipse-SDK-3.5.1-win32/eclipse','aaa');
insert table1 values('D:/eclipse-SDK-3.6.1-win32/eclipse','aaa');
insert table1 values('D:/eclipse-SDK-3.4.1-win32/eclipse','aaa');
insert table1 values('D:/jakarta-tomcat-5.1.12','aaa');
insert table1 values('D:/jakarta-tomcat-5.2.12','aaa');
insert table1 values('D:/jakarta-tomcat-5.3.12','aaa');
insert table1 values('D:/jakarta-tomcat-5.4.12','aaa');
insert table1 values('D:/jakarta-tomcat-5.5.12','aaa');
--- 操作语句
declare @a varchar(50)
declare @b varchar(50)
set @a='sdk' --要查找的字符串
set @b='sd' --要替换的字符串
select '替换前------'
select* from table1
update table1 set b=@b where PATINDEX ('%'+@a+'%',a)>0 ;
set @a='tomcat' --要查找的字符串
set @b='tom' --要替换的字符串
update table1 set b=@b where PATINDEX ('%'+@a+'%',a)>0 ;
select '替换后------'
select* from table1
-- select* from table1 where PATINDEX ('%'+@a+'%',a)>0 ;