Çó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µÄÔÓÐÎÊÌ⣬»ù±¾ÉÏÒ²ÊǰÑÔʼ±í½âÂë³ÉÕâÖÖ¸ñʽ£¬ÔÙÓþۼ¯º¯Êýͳ¼Æ¡£
Ïà¹ØÎÊ´ð£º
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
½«Ò»¸ö²éѯÓï¾ä¸³¸øÒ»¸ö±äÁ¿£¬ÈçÏ£º
DECLARE @STR NVARCHAR(MAX)
SET @STR='SELECT * from SALE_PROD'
ÔõôÑù²ÅÄÜÖ´ÐÐËüÄØ£¿
Çë¸ßÊÖ£¬ÈÊÐÖ£¬ÏÀ½ã°ï°ïæ°¡
¶àл£¬¿ÉÒÔÀ²£¬¸ßÊÖ°¡
Ö±½ÓÖ´ÐоÍÐÐÁË
exec ......
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µÄ²éѯÖÐÖ´ÐÐÏÂÃæµÄÓï¾ä,ÎÞЧ,ÌáʾÆÚ´ýselect ,updata ,...
CreateTble C=Answer N="»ØÌû±í"
(
C=ID T="INTEGER" P=No M=No N="񅧏" Z=false,
C=Ques ......