-----------------------------------------------
解答:小梁,沟沟
整理:htl258 (tony)
时间:2009-04-24
-----------------------------------------------
DECLARE @t TABLE(id INT,document NVARCHAR(MAX))
INSERT @t VALUES(1,N'XX是天才啊..AAA就是天才啊..');
UPDATE @t SET
document.write(null,CHARINDEX(N'AAA',document)+LEN('AAA')-1,null);
SELECT * FROM @t;
/*
id document
----------- -----------------------------------------------------------------
1 XX是天才啊..AAA
(1 行受影响)
*/
--SQL2000
--TEXT支持SUBSTRING,PATINDEX,CHARINDEX函数
DECLARE @t TABLE(id INT,document NVARCHAR(MAX))
INSERT @t VALUES(1,N'XX是天才啊..AAA就是天才啊..');
UPDATE @t SET
document =CASE WHEN CHARINDEX('AAA',document )>0
THEN SUBSTRING(document ,1,CHARINDEX('AAA',document )+LEN('AAA')-1)
ELSE document
END
SELECT * FROM @t;
/*
id document
----------- -----------------------------------------------------------------
1 XX是天才啊..AAA
(1 行受影响)
*/