ÓÐ2¸ö±í°¡£º
±íÃû£ºyh
Óû§±àÂë Óû§Ãû³Æ
001 a
002 b
003 c
±íÃû£ºys
Óû§±àÂë ±¾ÆÚÖ¸Êý ³±íʱ¼ä
001 11 2009-01-13
001 2 2009-02-26
002 ......
Äê¼¶±í:Ò»¸öÄê¼¶ÓÐ5¸ö°à,ÕâÀï¼Ç¼ÁËÊÇij¸öÄê¼¶Ò»¸ö°à¼¶Ä¬ÈÏÈËÊý
Äê¼¶ °à¼¶Ä¬ÈÏÈËÊý
Ò»Äê¼¶ 30
¶þÄê¼¶ 35
ÈýÄê¼¶ 40
°à¼¶±í:¼Ç¼ÁËÌØ±ð°à¼¶µÄʵ¼ÊÈËÊý,ûÓÐÁгöµÄ°à¼¶ÈËÊý¾ÍÊǸÃÄê¼¶µÄĬÈÏÈËÊý
°à¼¶ ʵ¼ÊÈËÊý
Ò»Äê¼¶Èý°à 40
Ò»Äê¼¶Îå°à 3 ......
ÓÐÁ½¸ö±í¸ñ A B
A ±í
AID NAME CONTENT
1 ÕÅÈý ÄãºÃÕÅÈý
2 ÀîËÄ ÄãºÃÀîËÄ
B ±í
BID AID PRICE
1 1 400
2 1 500
3 2 600
4  ......
sql 2005Êý¾Ý¿âÎÒÏëµÃµ½Ò»×Ö·û´®Îª:
sldkf|||sdeww
erkv|||rltdk
jemcl|||ligf
¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð»
ÔÎ µ½´¦·¢
SQL code:
select parsename(replace('sldkf|||sdeww','|||','.'),1)
/*sdeww*/
ÒýÓÃ
ÔÎ ......
ÎÒÒª×öÒ»¸ö¶¨µãʼþ£¬ÊÇÿÌìÍíÉÏ12µã¾Í°ÑÈý¸ö±íÀïµÄÐÅÏ¢·ÅÈëÒ»¸ö±íÀÎÒÏëÓô洢¹ý³ÌÀ´Ð´£¬ÔõÃ´Ð´ÄØ£¿£¬ÄÇλ¸ßÊÖ°ï°ïæ°É£¬·Ç³£¸Ðл£¡
Óû§ÃûÊÇΨһµÄ
±íA ×Ö¶Î
Óû§Ãû£ºName ,ÓÊÏ䣺Email£¬ ÁªÏµµç»°£ºPhome
±íB ×Ö¶Î
Óû§Ãû£ºName £¬ ½»Ò××ʽð£ºCapital £¬Ê ......
³¡¾°ÈçÏ£º
¿Í»§°Ñ±¸·ÝºÃµÄÊý¾Ý¿â£¬·¢¸øÎÒ£¬ÎÒÔÚ±¾»ú»¹Ôºó£¬ÔËÐÐдºÃµÄ´æ´¢¹ý³Ì£¬±È½Ï¿ì£¬²¢ÇÒÔÚʵʩÄDZßÔËÐÐͬÑù±È½Ï¿ì¡£µ«Êǵ±ÊµÊ©ÔÚ¿Í»§ÄDZßÔËÐеÄʱºòËٶȾͷdz£µÄÂý£¬Ê±¼ä³¬³öÁ˳ÌÐòµÄʱ¼äÏÞÖÆ¡£Ô¶³ÌÔÚ¿Í»§ÄDZßÇåÀíÁËËùÓÐɨÃèÃܶÈСÓÚ98%µÄË÷ÒýË鯬£¬µ«ÊÇЧ¹û»¹ÊDz»ÊǺÜÃ÷ÏÔ¡£²»Çå³þ»¹ÓÐʲôÇé¿öÓ°ÏìÁËÐÔÄÜ¡£
PS:¿Í ......