DELPHIÏÂSQLÓï¾ä¸Ä´í - Delphi / Êý¾Ý¿âÏà¹Ø
sql:='select ¹¹¼þÆÀ·Ö±í2.³Ì¶È from ¹¹¼þÆÀ·Ö±í2,ÒªËØÈ¨ÖØ±í where' Ëð»µÀàÐÍ'=+''''+s1+''''+'and'+ '¹¹¼þÆÀ·Ö±í2.ÆÀ¹ÀÒªËØ='+''''+s2+'''';ÔËÐÐÌáʾ´íÎ󣬿ÉÄÜÊÇ'ºÅµÄÎÊÌ⣬×ÜÊǸ㲻¶®£¬²»ºÃÒâ˼Âé·³´ó¼Ò£¬Ð»Ð»
'select ¹¹¼þÆÀ·Ö±í2.³Ì¶È from ¹¹¼þÆÀ·Ö±í2,ÒªËØÈ¨ÖØ±í where Ëð»µÀàÐÍ = ''' +s1+''' and ¹¹¼þÆÀ·Ö±í2.ÆÀ¹ÀÒªËØ= '''+s2+''' '
Delphi(Pascal) code:
sql:='select ¹¹¼þÆÀ·Ö±í2.³Ì¶È from ¹¹¼þÆÀ·Ö±í2,ÒªËØÈ¨ÖØ±í where Ëð»µÀàÐÍ= ' + QuotedStr(s1) + 'and ¹¹¼þÆÀ·Ö±í2.ÆÀ¹ÀÒªËØ = ' + QuotedStr(s2);
¶¥
Ïà¹ØÎÊ´ð£º
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Ä ......
½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì »·¾³ÊÇSQL2000Êý¾Ý¿â
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
Ñ»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)
......
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP
²Î¿¼:http://hi.baidu.com/toiota ......
ÓÐÕâÑùÒ»ÌõSQL
Select Get_Costtaxrate(col1), Get_Tcostvalue(col1) from a
ÆäÖÐGet_Costtaxrate¡¢Get_Tcostvalue¶¼ÊǺ¯Êý£¬ÕâÁ½¸öº¯ÊýÀïÃæ¶¼ÊDzéÕÒÒ»¸ö´ó±í£¬Get_Tcostvalue»¹ÐèÒªµ÷ÓÃGet_C ......