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

sql È«ÎÄË÷Òý

1¡¢ÒªÆôÓÃÈ«ÎÄË÷Òý¹¦ÄÜÊ×ÏÈÐèÒª°²×°full text searchÈ«ÎÄË÷Òý·þÎñ
2¡¢Æô¶¯full text search·þÎñ
3¡¢ÏÈ´´½¨UniqueË÷ÒýºÍÈ«ÎÄË÷Òý£ºCREATE FULLTEXT INDEX ON table_name
4¡¢Ã¿¸ö±íÖ»ÔÊÐí´´½¨Ò»¸öÈ«ÎÄË÷Òý
ɾ³ýÈ«ÎÄË÷Òý DROP FULLTEXT INDEX ON table_name
È«ÎÄËÑË÷Óï¾ä£¬contains(),freeText()
×¢ÒâÊý¾Ý¿âµÄÅÅÐò¹æÔò£¬Chinese_PRC_CI_ASʱÖÐÎIJſɲéѯµ½ÕýÈ·½á¹û¡£
5¡¢Ê¾ÀýÓï¾ä£º
 
--¿ªÆôÊý¾Ý¿âÈ«ÎÄË÷Òý
SP_FULLTEXT_DATABASE 'enable'
--´´½¨±í
CREATE TABLE [dbo].[UserTB](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [fullname] [nvarchar](400) COLLATE Chinese_PRC_CI_AS NULL,
    [address] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
 
--дÈë²âÊÔÊý¾Ý
insert into usertb(fullname,address) values('ÀÏÖÜ','»ØÁú¹ÛµØÇø±±¾©²ýƽ');
insert into usertb(fullname,address) values('ÀÏÍõ','beijing city changping district hui long guan region');
insert into usertb(fullname,address) values('ÀÏÀî','beijingcitychangpingdistricthuilongguan region');
insert into usertb(fullname,address) values('ÀÏÆÅ','aaaaaaaaaa dddddddd');
--´´½¨Ë÷Òý
CREATE UNIQUE INDEX    ix_usertb_id ON usertb(id)
--´´½¨È«ÎÄË÷ÒýĿ¼
CREATE FULLTEXT CATALOG fa AS DEFAULT
--DROP FULLTEXT CATALOG FA
--CREATE FULLTEXT INDEX ON dbo.usertb(fullname) KEY INDEX ix_usertb_id 
--DROP FULLTEXT INDEX on usertb
--´´½¨È«ÎÄË÷Òý
CREATE FULLTEXT INDEX ON dbo.usertb(address) KEY INDEX ix_usertb_id 
--²âÊÔ²éѯ
SELECT * from userTB
--WHERE CONTAINS(address,'changpin')
--WHERE CONTAINS(address,'changping')
WHERE CONTAINS(address,'"aaa*"')
--WHERE CONTAINS(address,'"²ýƽ*"')
--WHERE CONTAINS(address,'²ýƽ')


Ïà¹ØÎĵµ£º

SQLÊý¾Ý¿â

l  ÔÚ³ÌÐòÖÐÆ´½ÓSQLÃüÁî
¿ÉÊÇÈçºÎÔÚC#³ÌÐòÖÐÔËÐÐÄØ£¿ÎÒÃǼǵÃÔÚÆÕͨµÄSQL²éѯÖУ¬Ò»°ãÐèÒª°Ñ²éѯÓï¾ä¸³Öµ¸øSalCommand.CommandTextÊôÐÔ£¬ÕâÀïÒ²¾ÍÏñÆÕͨµÄSQL²éѯÓï¾äÒ»Ñù£¬½«ÕâЩÓï¾ä¸³¸øSqlCommand.CommandTextÊôÐÔ¼´¿É¡£Òª×¢ÒâµÄÒ»µãÊÇ£¬ÆäÖеÄ"GO"Óï¾ä±êÖ¾×ÅSQLÅú´¦ÀíµÄ½áÊø£¬±àдSQL½Å±¾ÊÇÐèÒªµÄ£¬µ«ÊÇÔÚÕâÀïÊDz ......

SQL Á¬½Ó×Ö·û´®µÄ˵Ã÷


ת×Ô£ºhttp://hi.baidu.com/arslong/blog/item/b23307e76252342cb8382001.html
Item01
Á¬½Ó×Ö·û´®Öг£ÓõÄÉùÃ÷ÓУº
·þÎñÆ÷ÉùÃ÷£ºData Source
¡¢Server
ºÍAddr
µÈ¡£
Êý¾Ý¿âÉùÃ÷£ºInitial Catalog
ºÍDataBase
µÈ¡£
¼¯³ÉWindows
Õ˺ŵݲȫÐÔÉùÃ÷£ºIntegrated
Security
ºÍTrusted_Connection
µÈ¡£
ʹÓÃÊý¾Ý¿â ......

µÚ10Õ£ºSQLºÍTQuery¶ÔÏó

±¾ÕÂÊǹØÓÚ²éѯ¡£ÕâÊÇÒ»¸öÖ÷Ì⣬ÔÚºËÐĵĿͻ§/·þÎñÆ÷±à³Ì£¬Òò´ËÕâÊDZ¾Êé¸üÖØÒªµÄƪÕÂÖ®Ò»¡£
¸Ã²ÄÁϽ«±»·Ö³ÉÒÔÏÂÖ÷Òª²¿·Ö£º
ʹÓÃTQuery¶ÔÏó
ʹÓñ¾µØºÍÔ¶³Ì·þÎñÆ÷µÄSQLÀ´Ñ¡Ôñ£¬¸üУ¬É¾³ýºÍ²åÈë¼Ç¼
ʹÓÃSQLÓï¾äÀ´´´½¨Á¬½Ó£¬ÁªÏµÓαêºÍ³ÌÐò£¬ËÑË÷µ¥¸ö¼Ç¼
Õâ¸öËõд´ú±íµÄSQL½á¹¹»¯²éѯÓïÑÔ£¬Í¨³£ÊÇÃ÷ÏÔµÄÐø¼¯»ò˵à ......

SQL 2005ת»»³É2000 (SQL Server)


Ö±½Órestore»ò¸½¼ÓÓ¦¸ÃÊDz»ÐеÄ, Óýű¾+µ¼Êý¾Ý¿Ï¶¨Ã»ÓÐÎÊÌâ¡£
2005תµ½2000µÄ²½Öè
1. Éú³Éfor 2000°æ±¾µÄÊý¾Ý¿â½Å±¾
2005 µÄmanger studio
-- ´ò¿ª"¶ÔÏó×ÊÔ´¹ÜÀíÆ÷"(ûÓеĻ°°´F8), Á¬½Óµ½ÄãµÄʵÀý
-- ÓÒ¼üҪתµ½2000µÄ¿â
-- ÈÎÎñ
-- Éú³É½Å±¾
-- ÔÚ"½Å±¾Ïòµ¼"µÄ"Ñ¡ÔñÊý¾Ý¿â"ÖÐ, ......

ʵÓÃSQL語¾ä

http://blog.csdn.net/fenglibing/archive/2007/10/24/1841537.aspx
1¡¢½«Ò»¸ö±íÖеÄÄÚÈÝ¿½±´µ½ÁíÍâÒ»¸ö±íÖÐ
insert into testT1(a1,b1,c1) select a,b,c from test;
insert into testT select * from test; (Ç°ÌáÊÇ兩個±íµÄ結構ÍêÈ«Ïàͬ)
 
insert into notebook(id,title,content)
se ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ