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

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

Óбí
¶ùͯÐÕÃû ³öÉúÈÕÆÚ ½ÓÖÖÒßÃç ½ÓÖÖʱ¼ä
Àî¸ÖÑó 2010-01-29 A1B1F1F2 101U104O101U1033
¿õºÆÓî 2010-01-26 A1B1F1 101Q104N101Q
³Ì³É 2010-01-03 A1B1F1F2 1013103M1013
½¯ÁÖ¾ù 2010-01-03 A1B1B2F1F2{1 1014103M104M10141024104M
ÉòÑîºÆ 2010-01-03 A1B1B2F1F2{1 1014103N104N10141025104N
³ÌÁ¼Ó¢ 2010-01-03 A1B1B2F1F2{1 1014103M104L10141025104L
ÂÞ¿¡Ãú 2010-01-01 A1B1B2F1F2{1 1014103L104N10141025104N
Åí¿ÉȽ 2010-01-03 A1B1B2F1F2{1 1013103L104M10131026104M

±íÖнÓÖÖÒßÃçÖÐÁ½¸ö×Ö·ûΪһ×飬A1ΪAÖÖÒßÃçµÚ1Õë A1¶ÔÓ¦½ÓÖÖʱ¼ä£¨101U£©Ëĸö×Ö·ûΪһ×飬101U£¨10±íʾ2010Ä꣬1±íʾ1ÔÂ,UΪ(ÈýÊ®¶þ½øÖÆ)±íʾ29ÈÕ¡£
ÈçºÎÓÃÒ»ÌõÓï¾äÇóµÃA1 B1 B2 F1 F2 {1 ÔÚ½ÓÖÖʱ¼ä£¨2010Äê4ÔÂ1ÈÕ—4ÔÂ30)ÖеļǼÊý

¼È½á¹û£º
A1£º0
B1£º3
B2£º5
F1£º0
F2£º0
{1£º5

Â¥Ö÷°ïÄ㶥һϰɣ¬ÏÈÏëÒ»ÏÂ

¼ÈÈ»Éè¼ÆÁËÕâÑù½ô´Õ»ÞɬµÄ±àÂë·½°¸£¬¾Í¿Ï¶¨ÓнâÂë·½·¨¡£

Ö»ÊÇÕâʵÔÚ²»ÊÇʲôºÃµÄÉè¼Æ£º
1. ½ÚÊ¡ÕâÒ»µã¿Õ¼ä£¬´úÂëÊǼÆËãÁ¿±¶Ôö£¬µÃ²»³¥Ê§¡£
2. ²»ÄܼǼ½ÓÖÖÒßÃçµÄÀúÊ·¼Ç¼¡£

µ¹²»·ÁרÃżÓÒ»ÕŽÓÖÖÒßÃç±í£¨¶ùͯÐÕÃû£¬ÒßÃçÖÖÀ࣬µÚ¼¸Õ룬½ÓÖÖʱ¼ä£©£¬ÆäÖÐÒÔ¼ÓÏ»®ÏßµÄ×Ö¶ÎΪÖ÷¼ü¡£

LZµÄÔ­ÓÐÎÊÌ⣬»ù±¾ÉÏÒ²ÊǰÑԭʼ±í½âÂë³ÉÕâÖÖ¸ñʽ£¬ÔÙÓþۼ¯º¯Êýͳ¼Æ¡£

ÒýÓÃ
¼ÈÈ»Éè¼ÆÁËÕâÑù½ô´Õ»ÞɬµÄ±àÂë·½°¸£¬¾Í¿Ï¶¨ÓнâÂë·½·¨¡£

Ö»ÊÇÕâʵÔÚ²»ÊÇʲôºÃµÄÉè¼Æ£º
1. ½ÚÊ¡ÕâÒ»µã¿Õ¼ä£¬´úÂëÊǼÆËãÁ¿±¶Ôö£¬µÃ²»³¥Ê§¡£
2. ²»ÄܼǼ½ÓÖÖÒßÃçµÄÀúÊ·¼Ç¼¡£


Ïà¹ØÎÊ´ð£º

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Óï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

¹ØÓÚSqlµÄÎÊÌâ - .NET¼¼Êõ / ASP.NET

½«Ò»¸ö²éѯÓï¾ä¸³¸øÒ»¸ö±äÁ¿£¬ÈçÏ£º
DECLARE @STR NVARCHAR(MAX)
SET @STR='SELECT * from SALE_PROD'
ÔõôÑù²ÅÄÜÖ´ÐÐËüÄØ£¿
Çë¸ßÊÖ£¬ÈÊÐÖ£¬ÏÀ½ã°ï°ïæ°¡


¶àл£¬¿ÉÒÔÀ²£¬¸ßÊÖ°¡

Ö±½ÓÖ´ÐоÍÐÐÁË

exec ......

asp wap sqlÓï¾äÖлñÈ¡µÄºº×Ö²»ºÃÊ - Web ¿ª·¢ / ASP

SQL code:

rs.open "select * from guide where city_name='±±¾©' order by pai desc",conn,1,1
do while not rs.eof or rs.bof
¡£¡£
¡£¡£
¡£¡£
rs.movenext
loop
Õâ¸ösqlÓï¾äÔÚwapÕ¾Àï ±¾ÉíÓÐ ......

Accessͨ¹ýSqlÓï¾ä´´½¨Êý¾Ý¿â - .NET¼¼Êõ / C#

ÔÚAccessµÄ²éѯÖÐÖ´ÐÐÏÂÃæµÄÓï¾ä,ÎÞЧ,ÌáʾÆÚ´ýselect ,updata ,...
CreateTble C=Answer N="»ØÌû±í"
(
  C=ID T="INTEGER" P=No M=No N="±àºÅ" Z=false,
  C=Ques ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ