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

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


Ïà¹ØÎÊ´ð£º

mssqlºÃ¶à±í¶¼"Ö»¶Á"

×î½üÏÂÃæ·´Ó¦Ëµ³ÌÐòÒì³£
È»ºó´ò¿ªÊý¾Ý¿âÒ»¿´
·¢Ïֺܶà±í¶¼"Ö»¶Á"״̬??
ÓÃsaµÇ½ҲÊÇ...
ºÜÆæ¹Ö°¡..
´óÅ£ÖªµÀÊÇʲôԭÒòÂð?
Ô¸Òâ³ö¸ß·ÖÇó
Ë­½â¾öÁË
¸ø200·Ö!!
Êý¾Ý¿â³öÎÊÌâÁË?

ÒýÓÃ
×î½üÏÂÃæ ......

MSSQLÈçºÎ²åÈë²»ÏàͬµÄ¼Ç¼ - .NET¼¼Êõ / ASP.NET

ÈçÌ⣬Óû§×¢²áʱ£¬Óû§ÃûÊDz»ÄÜÖØ¸´µÄ£¬ÈçºÎÅжϲåÈëµÄ¼Ç¼²»Öظ´ÄØ£¿
Çë¿´Çå³þÎÒµÄÌâÄ¿£¬²»Òª´ÓÍøÉϳ­Ò»Ð©´ð°¸¹ýÀ´£¬ÍøÉϺܶàÈËдµÄÏÈselectÔÙinsertµÄ¶¼ÊÇϹ³¶£¬Ñ¹¸ù¾Íû¿¼Âǵ½²¢·¢ÐÔÎÊÌ⣬ÎÒÏÖÔÚ²»Ïë¼ÓÉÏÐòÁл¯ ......

MSSQLÔõô»ñÈ¡Êý¾Ý¿âÀúÊ·²éѯ×Ü´ÎÊý

ÈçÌ⣬MYSQLÓÖÔõô»ñÈ¡£¿
ÈçÌâ

Õâ¸ö¹À¼ÆÔÚÈÕÖ¾ÎļþÖвÅÄÜ¿´¼û°É

Õâ¸ö¹À¼ÆÔÚÈÕÖ¾ÎļþÖвÅÄÜ¿´¼û°É


ÒýÓÃ
³ý·ÇÄãÒµÎñÉÏ×ö¼Ç¼£¬·ñÔòÄãÊDz»ÄÜÖªµÀµÄ¡£ÒòΪÈÕÖ¾²»¼Ç¼selectÓï¾äÃüÁî¡£
..

ÄÇÓÐûÓÐϵͳ´ ......

¹ØÓÚMSSQLĬÈÏÖµµÄÎÊÌâ

ÎÒÔÚMSSQL¹ÜÀíÆ÷Àï°Ñн¨×Ö¶Îstr

ÔÚĬÈÏÖµ»ò°ó¶¨ÄÇÀïÎÒÌîдÁË0

È»ºóÎÒ·¢ÏÖ¡£Èç¹ûÎÒÔÚÔö¼Ó¼Ç¼ʱ¡£Õâ¸öSTR²¢²»ÊÇĬÈϵÄ0¶øÊÇNULLÔõô»ØÊ£¿£¨ÔÚÔö¼Ó×Ö¶Îʱ¡£ÎÒûÓмÈërs("str")µÄÖµ¡£Ô­±¾Ò ......

asp mssql¿ª·¢ÎÊÌâ

ÎÒ¼ÒÓõÄÊÇXP
Ô­À´ÊǸãasp access¿ª·¢
ÏÖÔÚÓÐÒ»¸öÏîĿҪmssql
xpÎÒÓÖ²»ÄÜ×°sqlÆóÒµ°æ¡£ÇëÎÊÓÐûÓÐʲôÂÌÉ«»òÕߺõÄÈí¼þ½éÉÜ£¬ÄÜ´ò¿ªmssqlµÄmdf

ÒýÓÃ
ÎÒ¼ÒÓõÄÊÇXP
Ô­À´ÊǸãasp access¿ª·¢
ÏÖÔÚ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ