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

Ò»¸öSQLÓï¾äÇó½Ì

ÎҵıíÖÐÓÐÕâô¸ö×ֶΣ¬¸ñʽΪ£ºA@@B@@C

ÎÒµÄÒªÇó½«Õâ¸ö×ֶεÄÖµ±äΪ¶àÌõ£¬¼´£º1.A
                                    2.B
                                    3.C
ÔÚ²»Óô洢¹ý³ÌµÄÇé¿öÏ£¬ÓÃÒÔÌõSQLд³öÀ´£¬
ÏÖÔÚΨһÄÜÈ·¶¨µÄÊÇ@@ÊÇ·Ö¸ô·û£¬ÆäËûµÄ¶¼²»È·¶¨
ËùÒÔÒªÇóҪдÁé»îÒ»µã

ÎÒ×Ô¼ºÐ´³öÒ»¸ö£¬²»¹»Áé»î

ËùÒÔÏ£Íû¿´¿´´ó¼ÒÓÐʲôºÃÅ·½·¨Ã»ÓУ¬Ð»Ð»£¡
ÄǾÍÊÇ×Ö·û´®·Ö¸îÂһÌõsql£¬¹À¼ÆÓÐÄѶÈ

Ò»¶¨Òª¡°Ò»ÌõSQL¡±¸ãµàÂð£¿

¡£¡£ÎÒ²»Ì«ÏëÓô洢¹ý³Ì£¬ËùÒÔд³öÀ´´ó¼ÒÌÖÂÛÒ»ÏÂ
ÎÒ×Ô¼ºÐ´³öÁË¡£¡£²»¹ýÌ«³¤ÁË¡£¡£¡£
Ï൱ÓÚÒ»¸ö¶¯Ì¬SQLµÄ´æ´¢¹ý³ÌÁË¡£¡£

£¿£¿£¿£¿¹Ø×¢

Õâ¸öÊÇͦÄÑ

²»ÓÃPLSQLÔõô±£³ÖabcÄØ£¬±£³ÖÔÚÊý¾Ý¿âÖÐÒ²Òª±£³Ö¶à´Î°¡¡£Ò»ÌõsqlÔõô¸ã¶¨£¿
ÐãÏÂÄãµÄ³É¹û£¬Ñ§Ï°Ï¡£

itemValues=split(×Ö¶Î,"@@")
for m=0 to ubound(itemValues)
  if itemValues(m)="" then
  exit for
  end if

canshu=canshu+"¡ßitem¡à"+(m+1)+"¡¢"+itemValues(m)
        response.Write(canshu)

next
ÕâÊÇaspÖеĠ ¸Ä³ÉjavaÊÔÊÔ

ÒýÓÃ
itemValues=split(×Ö¶Î,"@@")
for m=0 to ubound(itemValues)
  if itemV


Ïà¹ØÎÊ´ð£º

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

sql º¯ÊýÎÊÌâ - MS-SQL Server / Ó¦ÓÃʵÀý

sqlÎÒÏëµÃµ½Ò»×Ö·û´®Îª:
sldkf|||sdeww
erkv|||rltdk
jemcl|||ligf
¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð»
ÔνñÌì²»ÊÇдÁËô

select parsen ......

sqlССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......

ÇóÒ»sqlÓï¾ä - MS-SQL Server / »ù´¡Àà

±í
id bh  
1 10
2 11
3 12 
4 15
5 16
6 22
7 25
8 26
9 27
10 28
½«bh°´Á¬Ðø·Ö¶Î³öÀ´·µ»Ø×Ö·û´®£º
10~12£¬15~16£¬22£¬25~28
SQL code:


declare @t tabl ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ