01.CREATE TABLE #001
02.(
03. [id] [int] IDENTITY(1,1) NOT NULL,
04. [base_word] [nvarchar](50) NULL,
05. [replace_word] [nvarchar](50) NULL
06.) ;
07.GO
08.INSERT INTO #001 ([base_word] , [replace_word] ) VALUES
09.(N'หยาบ' ,N'ละเอียด') ,
10.(N'หยาบมาก' ,N'ละเอียดมาก') ,
11.(N'หยาบมั่กๆ' ,N'ละเอียดมั่กๆ') ;
12.GO
13.
14.DECLARE MYFILTER_CURSOR CURSOR FOR
15. SELECT [base_word] ,[replace_word]
16. FROM #001 ORDER BY [base_word] ;
17.DECLARE @BASE_WORD_KEEPER NVARCHAR(MAX);
18.DECLARE @REPLACE_WORD_KEEPER NVARCHAR(MAX);
19.DECLARE @INPUT_TEXT NVARCHAR(MAX);
20.DECLARE @OUTPUT_TEXT NVARCHAR(MAX);
21.
22.SET @INPUT_TEXT = N'เมิงจะไปเที่ยวกะไปเดะกุมะไปง่วงว้อย สาดดดดดดดดดดดดด' ;
23.SET @OUTPUT_TEXT = @INPUT_TEXT ;
24.
25.OPEN MYFILTER_CURSOR ;
26.
27.FETCH NEXT FROM MYFILTER_CURSOR
28. INTO @BASE_WORD_KEEPER ,@REPLACE_WORD_KEEPER;
29.WHILE @@FETCH_STATUS = 0
30.BEGIN
31.
32. SET @OUTPUT_TEXT = REPLACE ( @OUTPUT_TEXT ,@BASE_WORD_KEEPER ,@REPLACE_WORD_KEEPER );
33.
34. FETCH NEXT FROM MYFILTER_CURSOR
35. INTO @BASE_WORD_KEEPER ,@REPLACE_WORD_KEEPER;
36.END
37.
38.CLOSE MYFILTER_CURSOR ;
39.DEALLOCATE MYFILTER_CURSOR ;
40.GO
41.DROP TABLE #001;
42.GO
Quote:
