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

ʹÓÃDelphiÈçºÎÁ¬½ÓSQLÊý¾Ý¿â£¿

×îºÃÄÜ˵µÄÏêϸµã
¾ÍÒ»¸öÁ¬½Ó×Ö·û´®£¬×Ô¼º·Å¸öadoconnectionÔÚ½çÃæÉÏ£¬Ë«»÷£¬È»ºóÑ¡ÔñbuildÔÚÁбíÖÐÑ¡Ôñ...for sql servÏÆäËû×Ô¼º¶Ô׎çÃæÉϵÄÄÚÈÝÈ¥¿´

¶î »¹ÊDz»Ì«Ã÷°× ´ÓÀ´Ã»ÓùýÕâ¶«Î÷


ÔÚÍøÉÏËÑÒ»ÏÂ

3Â¥µÄдµÃºÜϸÁË¡£

ÎÒÉÏ´«ÁËÆªÎÄÕ£¬Í¼ÎIJ¢Ã¯£¬¿ÉÒԲο¼Ò»Ï£ºÊ¹ÓÃDecision Cube½øÐÐÊý¾ÝµÄ¾ö²ß·ÖÎö
http://download.csdn.net/source/2222831

Èý¥дµÄºÜ×ÐϸÁË£¬ÒªÊÇ»¹Óв»Ã÷°×µÄ½¨ÒéÂ¥Ö÷Âò±¾DELPHIµÄÊé¿´¡£

Delphi(Pascal) code:

var
conn: Variant;//Connection
begin
//½¨Á¢Êý¾Ý¿âÁ¬½Ó
conn := CreateOleObject('ADODB.Connection');
try
conn.Open('Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=;Data Source='+ ASSECCÊý¾Ý¿â¾ø¶Ô·¾¶);
except //Á¬½Ó³ö´í
result := '';
exit;
end;
end;





ÔÙ¸øµã½¨Òé
Á¬½ÓSQLÊý¾Ý¿â£¬Òª·ÖÇåsqlµÄµÇ¼·½Ê½
SQL ServerÉí·ÝÑéÖ¤»¹ÊÇWindowsÉí·ÝÑéÖ¤
²»Í¬µÄµÇ¼·½Ê½Á¬½Ó×Ö·û´®Ò²²»Ò»Ñù
WindowsÉí·ÝÑéÖ¤
Delphi(Pascal) code:

Self.ADOConnection1.Connected:=False;
Self.ADOConnection1.ConnectionString:='Provider=SQLOLEDB.1;Integrated Security=SSPI;'
+'Persist Security Info=False;Initial Catalog=master';
try
Self.ADOConnection1.Connecte


Ïà¹ØÎÊ´ð£º

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

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

Êý¾ÝÒÔxml¸ñʽ·µ»Ø - MS-SQL Server / Ó¦ÓÃʵÀý

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......

ÇóÒ»sqlÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......

¸¶·ÑÇódelphiÆ´Òô±à³Ì - Delphi / ·Ç¼¼ÊõÇø

¾ßÌåÒªÇóÓ뱨³êQQ729851670
771234717

¡°Æ´Òô±à³Ì¡±ÊÇʲôÒâ˼

ÒýÓÃ
¡°Æ´Òô±à³Ì¡±ÊÇʲôÒâ˼
1.¸øÒ»¸ö×Ö¿ÉÒÔÏÔʾƴÒô£¬¶àÒô×ֵϰÄÜÏÔʾ¶ÔÓ¦µÄ¶à¸öÆ´Òô
2.¶Ô°üº¬¶àÒô×ֵĴÊÓïÖÇÄÜʶ±ð¸ø³öÆ´Òô¡£
3.¶ÔÒ»¶Î ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ