sql server 替换语句

--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 ;