ÇóÒ»sqlÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡£¿
·Ç³£¸Ðл
Â¥ÉϵÄÏÈл¹ýÁË£¬²»¹ýÕâ¸öºÃÏñ²»¶Ô°É£¿»òÕßÎÒûÓÐÃèÊöÇå³þ
ÎÒÏÖÔÚÊÇÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÔÚÒ³ÃæÉÏÁгöÎÄÕµıêÌâÁÐ±í£¬ÆäÖÐÿƪÎÄÕÂÏÂÃæÁгöÊôÓÚ´ËÎÄÕµÄËùÓÐÆÀÂÛÐÅÏ¢¡£
ÕâÑùµÄÓï¾äÔõôд°¡£¿
»òÕßÖ»ÄÜÊǵÚÒ»´ÎÖ»ÊÇÁгöÎÄÕ±êÌ⣬Ȼºóÿ¼ÓÔØÒ»ÌõÎÄÕ¾ÍÈ¥Êý¾Ý¿â²éѯһ´ÎËùÓÐµÄÆÀÂÛ£¿ÕâÑùÈç¹ûÿҳÏÔʾ10ÌõµÄ»°£¬ÄÇÕâ¸öÒ³ÃæÖÁÉÙÒªÁ¬½ÓÊý¾Ý¿â½øÐÐ11´Î£¬ÕâÑùЧÂÊÊDz»ÊÇÓÐЩµÍ°¡£¿
ÒÔÄĸöΪ׼£¿
(²»Òª¸ß¹ÀÄãµÄººÓï±í´ïÄÜÁ¦»òÕßÎҵĺºÓïÀí½âÄÜÁ¦)
½¨ÒéÄãÁгöÄãµÄ±í½á¹¹£¬²¢Ìṩ²âÊÔÊý¾ÝÒÔ¼°»ùÓÚÕâЩ²âÊÔÊý¾ÝµÄËù¶ÔÓ¦ÕýÈ·½á¹û¡£
²Î¿¼Ò»ÏÂÕâ¸öÌù×ÓµÄÌáÎÊ·½Ê½http://topic.csdn.net/u/20091130/20/8343ee6a-417c-4c2d-9415-fa46604a00cf.html
1. ÄãµÄ create table xxx .. Óï¾ä
2. ÄãµÄ insert into xxx ... Óï¾ä
3. ½á¹ûÊÇʲôÑù£¬£¨²¢¸øÒÔ¼òµ¥µÄËã·¨ÃèÊö£©
4. ÄãÓõÄÊý¾Ý¿âÃû³ÆºÍ°æ±¾(¾³£ÓÐÈËÔÚMS SQL server°æÎÊ MySQL)
ÕâÑùÏë°ïÄãµÄÈË¿ÉÒÔÖ±½Ó´î½¨ºÍÄãÏàͬµÄ»·¾³£¬²¢ÔÚ¸ø³ö·½°¸Ç°½øÐвâÊÔ£¬±ÜÃâÎÄ×ÖÃèÊöÀí½âÉϵÄÎó²î¡£
Â¥ÉϵIJ»ºÃÒâ˼
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
ÎÒÒªµÃµ½Ò»¸ö×Ö·û´®È磺
sdfk|||sgts
sdfsfd|||rgreg
wrfw|||sefw
¾ÍÊÇÒªµÃµ½|||ºóÃæµÄ×Ö·û´®£¬ÓÐʲôº¯ÊýÂð£¿ÔõôÓÃÄØ£¿Ð»Ð»£¡
SQL code:
select
right(col,len(col)-charindex('|||',col)-2)
f ......
sqlÎÒÏëµÃµ½Ò»×Ö·û´®Îª:
sldkf|||sdeww
erkv|||rltdk
jemcl|||ligf
¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð»
ÔνñÌì²»ÊÇдÁËô
select parsen ......
Êý¾Ý¿âÒªÔõôѧ²Å²»»áÏԵóéÏó°¡£¿
Õâ¾ÍÒª¿´ÄãÊʺÏʲô·½·¨ÁË£¬Õâ¾ßÌå²»ºÃ˵µÄ.....
ÔõôÁË£¬ÄѵÀ´ó¼Ò¶¼²»»á£¬»¹ÊÇÕæµÄÌ«³éÏó´ó¼Ò²»ÖªµÀÔõô˵°¡
½áºÏÄã²Ù×÷Êý¾Ý¿âµÄÌå»áºÍÀí½â£¬Ó¦¸ÃЧ¹û»á¸üºÃ¡£·ñÔò£¬Ò ......
½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì »·¾³ÊÇSQL2000Êý¾Ý¿â
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
Ñ»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)
......