mssql 2005Êý¾Ý¿â Ä£ºý²éѯ ¼±¡£¡£
mssql 2005 ÊÇÓ¢ÓïÕý°æµÄ¡£
²»ÖªµÀΪʲôÀýÈç
select content_cn,content_ru from table where content_cn like '%ÖÐÎÄ%'
select content_cn,content_ru from table where content_ru like '%¶íÓï%'
select content_cn,content_ru from table where content_cn like '%Ó¢Óï×Ö·û%'
ÒÔÉÏÈýÌõÓï¾ä ÎÒÔÚ±¾»ú Ãâ·Ñ°æµÄ2005 É϶¼¿ÉÓà ÎÒ¿ÉÊÇÔÚ ÎÒÂòµÄÕý°æ2005Êý¾Ý Ö´ÐÐÕßÈýÌõÓï¾ä
Ö»ÓÐ Ó¢Óï×Ö·û¿ÉÒÔËÑË÷µ½½á¹û ÖÐÎÄ »òÆäËû×Ö·û¶¼²»¿ÉÒÔ ²»ÖªµÀΪʲôÐèÒªÉèÖÃʲô£¿
ÄãÓ¢ÎÄ°æµÄÅÅÐò¹æÔòÊÇʲô£¿
ÔÚSQLÀï¼ÓÉÏ¡®N¡¯Ç¿ÖÆת»»±àÂë
È磺
SQL code:
insert into table(aa,bb) values(N'ÖÐÎÄ1',N'ÖÐÎÄ2')£¬
select content_cn,content_ru from table where content_cn like N'%ÖÐÎÄ%'
¼ÓÉÏSQL code:
N'
ÓÃÀ´±íʾǿÖÆת»»ÎªNational Unicode¡«
²é¿¼£ºhttp://kitesky.itpub.net/post/909/16260
Ïà¹ØÎÊ´ð£º
ÓÐ沒ÓÐ辦·¨實現£¬從MSSQL2000Æó業¹ÜÀíÆ÷註冊MSSQL2008數據庫£¿
Á¬²»ÉÏ°É
òËÆ沒Ï£Íû¡£¡£¡£
Ó¦¸ÃÊDz»ÐÐµÄ ¿çÌ«¶àÁË
ÄÇ2000µÄ ......
±íµÄ½á¹¹ÈçÏ£º
±í1£ºtb_big
×ֶΣºfalseid Öµ£º1£¬2£¬
×ֶΣºbigtype Öµ£ºA£¬B£¨ÓëfalseidµÄÖµµÄλÖÃÒ»Ò»¶ÔÓ¦£¬¼´1¶ÔÓ¦A£¬2¶ÔÓ¦B£©
±í2£ºtb_small
×ֶΣºfalseid£¨Óëtb_bigµÄfalseid_1¹ØÁªµ ......
±íµÄ½á¹¹ÈçÏ£º
±í1£ºtb_big
×ֶΣºfalseIDÖµ£º1£¬2£¬3
×ֶΣºbigtype Öµ£ºA£¬B£¬C£¨ÓëfalseIDµÄÖµµÄλÖÃÒ»Ò»¶ÔÓ¦£¬¼´1¶ÔÓ¦A£¬2¶ÔÓ¦B£©
±í2£ºtb_small
×ֶΣºfalseID£¨Óëtb_bigµÄfalseID ......
ÈçÌ⣬MYSQLÓÖÔõô»ñÈ¡£¿
ÈçÌâ
Õâ¸ö¹À¼ÆÔÚÈÕÖ¾ÎļþÖвÅÄÜ¿´¼û°É
Õâ¸ö¹À¼ÆÔÚÈÕÖ¾ÎļþÖвÅÄÜ¿´¼û°É
ÒýÓÃ
³ý·ÇÄãÒµÎñÉÏ×ö¼Ç¼£¬·ñÔòÄãÊDz»ÄÜÖªµÀµÄ¡£ÒòΪÈÕÖ¾²»¼Ç¼selectÓï¾äÃüÁî¡£
..
ÄÇÓÐûÓÐϵͳ´ ......
ÎÒ¼ÒÓõÄÊÇXP
ÔÀ´ÊǸãasp access¿ª·¢
ÏÖÔÚÓÐÒ»¸öÏîÄ¿Òªmssql
xpÎÒÓÖ²»ÄÜ×°sqlÆóÒµ°æ¡£ÇëÎÊÓÐûÓÐʲôÂÌÉ«»òÕߺõÄÈí¼þ½éÉÜ£¬ÄÜ´ò¿ªmssqlµÄmdf
ÒýÓÃ
ÎÒ¼ÒÓõÄÊÇXP
ÔÀ´ÊǸãasp access¿ª·¢
ÏÖÔÚ ......