SQLÈçºÎÓÅ»¯ÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ
½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì »·¾³ÊÇSQL2000Êý¾Ý¿â
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
Ñ»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)
¶¨Ò幫˾¹¤×ÊÏîÄ¿Óαê
Ñ»·¸Ã¹«Ë¾¹¤×ÊÏîÄ¿(ÓÐ50¸ö×óÓÒ¹¤×ÊÏîÄ¿)
£¨ÓÐЩ¿ÉÒÔÖ±½Ó´Ó¹¤×ʱíÀïÃæÖ±½ÓÈ¡³öÀ´ ±ÈÈçÌõ¼þÊǹ¤×ÊÏîÄ¿±àºÅ=2
µ«ÊÇÓÐЩ²»ÄÜÖ±½ÓÈ¡ ±ÈÈ繤×ÊÏîÄ¿±àºÅ2+ ¹¤×ʱàºÅ3µÈµÈ
¼ÆËãÁ¿¿ÉÄܱȽϴó ÕâÀïµÄSQL¶¼ÊǶ¯Ì¬Éú³É³öÀ´µÄ£©
ÿ´ÎÓÃexec sp_executesql ¼ÆËã½á¹û
½áÊøÑ»·¸Ã¹«Ë¾
Ïà¹ØÎÊ´ð£º
±íÈçÏÂ
½ÌÊÒID ×ùλÊý ¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä 2009Äê1ÔÂ1ÈÕ 2009Äê1ÔÂ2ÈÕ 2009Äê1ÔÂ3ÈÕ
101 50 08£º00 08£º30 30 40 50
101 50 09£º00 ......
ÎÒÒªµÃµ½Ò»¸ö×Ö·û´®È磺
sdfk|||sgts
sdfsfd|||rgreg
wrfw|||sefw
¾ÍÊÇÒªµÃµ½|||ºóÃæµÄ×Ö·û´®£¬ÓÐʲôº¯ÊýÂð£¿ÔõôÓÃÄØ£¿Ð»Ð»£¡
SQL code:
select
right(col,len(col)-charindex('|||',col)-2)
f ......
´ó¼ÒºÃ£¬ÎÒ×î½üά»¤Ò»¸öÏîÄ¿£¬100¶à¸ö±í
Ö»ÄÜÓÃjdbcÖ±Á¬
Óöµ½Á˶à¸ö±í ¹ØÁª ²éѯµÄÇé¿ö Çë´ó¼ÒÖ¸½Ì
±ÈÈç
student(studentid,classid)
class(classid,classname)
class_teacher(classid,teacherid)Õâ¸öÊÇÖмä±í ......
Id Name Flag
1 ÕÅÈý 1
2 ÍõÎå 3
3 ÕÅÈý 1
4 ÀîËÄ 2
5 ÕÅÈý 1
6 ÀîËÄ 2
ÎÒÏëÊä³öµÄʱºò±ä³ÉÕâÑù
Id Name Flag
1 ÕÅÈý 1 & ......
Êý¾Ý¿âÒªÔõôѧ²Å²»»áÏԵóéÏó°¡£¿
Õâ¾ÍÒª¿´ÄãÊʺÏʲô·½·¨ÁË£¬Õâ¾ßÌå²»ºÃ˵µÄ.....
ÔõôÁË£¬ÄѵÀ´ó¼Ò¶¼²»»á£¬»¹ÊÇÕæµÄÌ«³éÏó´ó¼Ò²»ÖªµÀÔõô˵°¡
½áºÏÄã²Ù×÷Êý¾Ý¿âµÄÌå»áºÍÀí½â£¬Ó¦¸ÃЧ¹û»á¸üºÃ¡£·ñÔò£¬Ò ......