MSSQLÈ«ÎļìË÷
MSSQLÈ«ÎļìË÷ --1.´ò¿ªÊý¾Ý¿â
use pubs
go
--2.´ò¿ªÈ«ÎÄË÷ÒýÖ§³Ö
--execute sp_fulltext_database 'enable'
/*
£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
£¨ËùÓ°ÏìµÄÐÐÊýΪ 0 ÐУ©
£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
*/
--3.½¨Á¢È«ÎÄĿ¼ft_test
--execute sp_fulltext_catalog 'ft_test','create'
/*
ÃüÁîÒѳɹ¦Íê³É¡£
*/
--4.Ϊtitles±í½¨Á¢È«ÎÄË÷ÒýÊý¾ÝÔª£¬UPKCL_titleidindΪtitles±íÖÐÓÉÖ÷¼üËù½¨Á¢µÄΨһË÷Òý£¬´Ë²ÎÊý±ØÐë¡£
--execute sp_fulltext_table 'titles','create','ft_test','UPKCL_titleidind'
/*
£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
*/
--5.ÉèÖÃÈ«ÎÄË÷ÒýÁÐÃû
--execute sp_fulltext_column 'titles','title','add'
/*
£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
*/
--execute sp_fulltext_column 'titles','notes','add'
/*
£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
*/
--6.½¨Á¢È«ÎÄË÷Òý
--execute sp_fulltext_table 'titles','activate'
/*
ÃüÁîÒѳɹ¦Íê³É¡£
*/
--7.Ìî³äÈ«ÎÄË÷ÒýĿ¼
--execute sp_fulltext_catalog 'ft_test','start_full'
/*
£¨ËùÓ°ÏìµÄÐÐÊýΪ 0 ÐУ©
£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
*/
--8.ÖÁ´Ë£¬È«ÎÄË÷Òý½¨Á¢Íê±Ï¡£
1-6.
´ò¿ªpubsÊý¾Ý¿â£¬ÓÒ¼ütitles±í£¬Ñ¡Ôñ¡°È«ÎÄË÷Òý±í¡±£¬¡°ÔÚ±íÉ϶¨ÒåÈ«ÎÄË÷Òý¡±£¬ÎªÆä´´½¨È«ÎÄĿ¼¡£ÔÚ¡°È«ÎÄË÷ÒýÏòµ¼¡±ÖУ¬
Ñ¡ÔñÄãÐèҪȫÎIJéѯÌõ¼þµÄÁУ¨¿ÉÒÔÊÇÎı¾»òͼÏñ£©£¬ÎÒÃÇÑ¡ÔñtitleºÍnotesÁС£È»ºóÏÂÒ»²½£¬ÊäÈëÒ»¸öеÄĿ¼ft_test£¬µã»÷ÏÂÒ»²½¡£ÔÚÌî³äµ÷¶ÈÒ»ÏîÀÎÒÃÇÔÝʱ²»½¨Á¢Ìî³äµ÷¶È¡£½Ó×Å¡°ÏÂÒ»²½¡±£¬È«³ÉÈ«ÎÄË÷ÒýÏòµ¼¡£Íê³Éºó£¬ÎÒÃÇ¿
Ïà¹ØÎĵµ£º
ÔÚ´¦ÀíϵͳÓÅ»¯µÄʱºò£¬·¢ÏÖindexʹÓò»µ±µÄ»°£¬ÏµÍ³µÄÐÔÄܲ»Äܺܺ÷¢»Ó¡£
È磺½ñÌìµÄ·¢ÏÖµÄÒ»¸ösqlÓï¾ä£¬¾¹ý·ÖÎö£¬Ê¹ÓÃÁË2¸öindex¡£µ«ÊÇ2¸öindex·µ»ØµÄ¼Ç¼ÔÚ»¥ÏàÆ¥Åä¹ý³ÌÖкÄʱ×î¶à¡£ËùÒÔ£¬¼´Ê¹SQLÓï¾äʹÓÃindex£¬Ò²²»´ú±íÕâ¸öÓï¾äÔÚÐÔÄÜÉÏÊǺܺõġ£ ......
ÈçͼËùʾ£¬ÔÚ°²È«ÐÔ-µÇ½Àï¿ÉÒÔ¿´µ½ÓÒ±ßÁбíÀïµÄÓû§£¬Ñ¡ÖÐÓû§ÓÒ¼ü-ÊôÐÔ¿ÉÒÔ¸ü¸ÄÓû§ÃÜÂ룬¼°Êý¾Ý¿â½ÇÉ«µÈ¡£
²é¿´Óû§Ãû£¬¼°ÃÜÂëÊÇ·ñÕýÈ·£¬¿ÉÒÔµ¥¶ÀµÇ½ ²éѯ·ÖÎöÆ÷
Èç¹ûÄܵǽ˵Ã÷ÉèÖÃÕýÈ·£¬ÔÚmssql´î½¨µÄasp cmsÀï¾³£ÒªÓõ½Óû§Ãû£¬ÃÜÂë¡£
ÏÖÔÚ¿´Ã¿¸öÊý¾ÝÏÂÃæµÄÓû§Ñ¡ÏÈçͼ
Ñ¡ÖÐÒ»¸öÒ»¸öÊý¾Ý¿â£¬»òÏÂÃæµÄÓû§Ñ ......
SQL SERVER ºÍEXCELµÄÊý¾Ýµ¼Èëµ¼³ö
1¡¢ÔÚSQL SERVERÀï²éѯExcelÊý¾Ý:
-- ======================================================
SELECT *
from OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\book1.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...[Sheet1$]
ÏÂÃæÊǸö²éѯµÄʾÀ ......
create function dbo.regexReplace
(
@source varchar(5000), --Ô×Ö·û´®
@regexp varchar(1000), - ......