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£¬µã»÷ÏÂÒ»²½¡£ÔÚÌî³äµ÷¶ÈÒ»ÏîÀÎÒÃÇÔÝʱ²»½¨Á¢Ìî³äµ÷¶È¡£½Ó×Å¡°ÏÂÒ»²½¡±£¬È«³ÉÈ«ÎÄË÷ÒýÏòµ¼¡£Íê³Éºó£¬ÎÒÃÇ¿
Ïà¹ØÎĵµ£º
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 ......
ÔÚµçÄÔÉÏ×°Á˸öÐéÄâ»ú£¬±¾»ú×°Á˸öMSSQL2000,ÔÚÐéÄâ»úÒ²×°Á˸öMSSQL2000£¬µ«Êǵ±Á¬½ÓÐéÄâ»úÉϵÄMSSQL£¬SQLÌáʾ³ö´í£¬ÎÞ·¨Á¬½Ó£¬¾õµÃºÜÆæ¹Ö£¬ÒòΪIPµØÖ·ÊDz»Í¬µÄ£¬×îºóÏëµ½Á˸ö°ì·¨£¬ÒòΪÊÇһ̨µçÄÔ£¬ËùÒԶ˿Ú1433Ö»ÓÐÒ»¸ö£¬±¾»úÕ¼ÁË1433£¬ÄÇôÐéÄâ»ú¾Íû·¨ÓÃÁË£¬Ïëµ½¾Í×ö£¬°ÑÐéÄâ»úµÄ¶Ë¿Ú¸Ä³ÉÁË1500¡£ÖØÆôµçÄÔ£¬µ«ÊÇ»¹ÊDz»Ä ......
--SCHEMATA±íÌṩÁ˹ØÓÚÊý¾Ý¿âµÄÐÅÏ¢
select top 10 * from INFORMATION_SCHEMA.SCHEMATA
--TABLES±í¸ø³öÁ˹ØÓÚÊý¾Ý¿âÖеıíµÄÐÅÏ¢
select top 10 * from INFORMATION_SCHEMA.TABLES
--COLUMNS±í¸ø³öÁ˱íÖеÄÁÐÐÅÏ¢¡£
select top 10 * from INFORMATION_SCHEMA.COLUMNS
--VIEWS±í¸ø³öÁ˹ØÓÚÊý¾Ý¿âÖеÄÊÓͼµÄÐÅÏ¢
sel ......
MSSQL ÈçºÎʵÏÖ MySQL µÄ limit ²éѯ·½Ê½
²»ÖªÎªºÎ£¬MSSQL ÖÐûÓÐ limit Õâ¸ö¼«ÎªÖØÒªµÄ²éѯ·½Ê½£¬ÊìϤ MySQL µÄÅóÓѶ¼ÖªµÀ£¬MySQL µÄ limit ¶ÔÓÚʵÏÖ·ÖÒ³ºÍһЩÏÞÖƽá¹û¼¯µÄÓ¦ÓÃÖзdz£·½±ã¡£Ã»Óв»Òª½ô£¬ÎÒÃÇ¿ÉÒÔÓÃÆäËû·½·¨´ïµ½Í¬ÑùµÄÄ¿µÄ£¬×Ô¼º¶¯ÊÖ£¬·áÒÂ×ãʳ£¡
Óï·¨£º
Code:
SELECT * from
(
......
create function dbo.regexReplace
(
@source varchar(5000), --Ô×Ö·û´®
@regexp varchar(1000), - ......