Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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£¬µã»÷ÏÂÒ»²½¡£ÔÚÌî³äµ÷¶ÈÒ»ÏîÀÎÒÃÇÔÝʱ²»½¨Á¢Ìî³äµ÷¶È¡£½Ó×Å¡°ÏÂÒ»²½¡±£¬È«³ÉÈ«ÎÄË÷ÒýÏòµ¼¡£Íê³Éºó£¬ÎÒÃÇ¿


Ïà¹ØÎĵµ£º

MSsqlÿÌì×Ô¶¯±¸·Ý×Ô¶¯Çå³ýÈÕÖ¾µÄ²Ù×÷·½·¨

1¡¢Ã¿ÈÕ×Ô¶¯±¸·Ý
¡¡¡¡´ò¿ªÆóÒµ¹ÜÀíÆ÷£¬½øÈ듹ÜÀí”-“Êý¾Ý¿âά»¤¼Æ»®”£¬ÔÚÓҲര¿Úµã»÷ÓÒ¼ü£¬Ñ¡Ôñ“н¨Î¬»¤¼Æ»®”£¬Æô¶¯“Êý¾Ý¿âά»¤¼Æ»®Ïòµ¼”;µã»÷“ÏÂÒ»²½” Ñ¡ÔñÐèҪά»¤µÄÊý¾Ý¿â£¬Î¬»¤ÌØÐÔÊý¾Ý¿âʱ£¬Ñ¡Ôñ×îºóÒ»¸öµ¥Ñ¡¿ò²¢¹´Ñ¡ÐèҪά»¤µÄÊý¾Ý¿âÃû³Æ;“ÏÂÒ» ......

MsSql ºÍ Oracle ¿çÊý¾Ý¿â²éѯ

SQL
insert into   table_name(colum1,colum2)
select  colum1,colum2
 from  opendatasource('sqloledb','data source=·þÎñÆ÷Ãû;user id=Óû§Ãû ;password=ÃÜÂë ').database_name.dbo.table_name
ÈçÖ´ÐгöÏÖÒÔÏ´íÎó”sql server ×èÖ¹Á˶Ô×é¼þ \'ad hoc distributed queries\' µÄ·ÃÎÊ&l ......

MSSQLÈÕÖ¾Îļþ¼°Æä´¦ÀíÏê½â


ÈçºÎÇå³ýMSSQLÊÂÎñÈÕÖ¾Îļþ
   ÈýÖÖ·½·¨£º  
    
1¡¢É¾³ýLOG  
    
   1)£º·ÖÀëÊý¾Ý¿âÆóÒµ¹ÜÀíÆ÷£­£¾·þÎñÆ÷£­£¾Êý¾Ý¿â£­£¾ÓÒ¼ü£­£¾·ÖÀëÊý¾Ý¿â      
   2)£ºÉ¾³ýLOGÎļþ  & ......

MSSQL Óë EXCEL»¥²Ù×÷

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$]
ÏÂÃæÊǸö²éѯµÄʾÀ ......

Linux»·¾³µÄAMP°²×° MSSQLÀ©Õ¹°²×°


LinuxÒª°²×°mssqlÀ©Õ¹£¬±ØÐëÊ×ÏÈ°²×°freetds£¬°²×°¹ý³ÌÈçÏ£º
1¡¢¼ÙÉèÔ´ÎļþĿ¼Ϊ/webServ£¬°²×°Ä¿Â¼Îª/opt/freetds¡£
1) >cd /webServ
2) ÏÂÔØ£¬ >wget ftp://ftp.ibiblio.org/pub/Linux/ALPHA/freetds/stable/freetds-stable.tgz
3) ½âѹ£¬ >tar -zxvf freetds-stable.tgz
4) ½øÈ룬 >cd freetds-0¡£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ