全文索引删除干扰词（Full text index deleting interference words）.docVIP

全文索引删除干扰词（Full text index deleting interference words） Full text indexing remove noise words.Txt26 choose self-confidence, is to choose easy, is the choice of its fame in front, is to choose the forces in front of distraction confident sail go with head high and chest out, breaking the flow forward, the shows style fighting. Full text index, delete word.Txt, handsome men shake hands, and deep men talk about hearts, communicate with successful men, and live with ordinary men. 1., the search word used is to ignore the words, of course, I use the search term is certainly in the current system seems to be ignoring the word, no doubt. But usually not ignore words, words have become ignored, the word is not normal. The 2. ignore word is contained in the file named noise.*, which is placed under the MSSQL\FTDATA\SQLServer\Config directory of the MSSQL installation directory, for example, the Chinese ignore words are placed in noise.chs. 3., I suddenly found that my computer does not have noise.chs, and my computer is not working properly. 4., because the server is not convenient to connect, I installed a MSSQL on the edge of the computer that did not install SQL, but I was disappointed that it did not generate noise.chs after installation 5. I try holding the mood, did not expect in the C drive under the system32 directory to find a file called noise, I will copy all of them to the MSSQL installation directory MSSQL\FTDATA\SQLServer\Config, expect a miracle has occurred, you can normally use the full-text index Chinese! Finally, attach a zip file, if you do not have such noise files, you can download here Http:///product/others/noise.zip Include the following, and then call: remove_noise_word () SCRIPT LANGUAGE=javascript ! -- Noise_word_list_ch = new (Array?, about, $, 1, 2, 3, 4, 5, 6, 7, 8, 9, 0, _, A, B, C, d, e, F, g, H, I, J, K, L, m, n, O, , P, Q, R, s, t, U, V, W, X, Y, Z, after, all, also, An, and, another, any, are, as, at, be, because, been, Before, being, betwe