ÍøÕ¾´ò°ü£¬ÄÜ´ò³ÉmssqlµÄ±í²»Èÿͻ§¿´µ½ÄÚÈÝÂð
ÈçÌ⣬Ï뽫ÎÒÒÔǰ×ö¹ýµÄÍøÕ¾·ÅÔÚÍøÉϸøÈË¿´£¬ÓÉÓÚÊÇms sqlµÄ£¬´ó¶àÊýÍøÂçÉ̵ÄÐéÄâÖ÷»úÊÇÒªÊշѵģ¬
Ïë´ò°üºó·ÅÔÚһЩÃâ·ÑµÄ¿Õ¼ä£¬ÈÃÈ˼Ò×Ô¼ºÏÂÔØÈ¥¿´£¬ËùÒÔÏ£Íû´ò¹ý°üºóµÄÊý¾Ý¿âµÄ±í²»Èÿͻ§¿´µ½£¬
»òÕßÊǼӹýÃܵÄ
ÄÄλ¸ßÊÖÖ¸µãÒ»ÏÂ
sqlserverµÄÊý¾Ý¿â´ò°ü?Èç¹ûÊÇaccesseÖ®À۵ıȽϼòµ¥ ¸Ä¸ömdb¼´¿É,mssqlserver?
Â¥Ö÷µÄÒâ˼ÊÇʲôѽ£¡ÓÖ¿ÉÒÔ¿´£¬ÓÖ²»¿ÉÒÔ¿´£¡
Êý¾Ý¿â¼ÓÃÜ£¿£¿
http://blog.csdn.net/fredrickhu/archive/2009/09/20/4574249.aspx
ÕâÑùµÄÂð£¿
×Ô¼ºÓÃǰ̨ӦÓóÌÐòÖ´ÐÐÄãµÄ½¨±íÎļþ¡¡£¬ÄãµÄÎļþ¼ÓÃܵķ½Ê½¶àÁË£¬¿ÉÒÔwinrar¡¡£¬ÕâÑù¸øÓû§ÏÂÀ´µÄÊÇÒ»¸ö¿ÉÖ´ÐÐÎļþ£¨ÄÜÅäÖÃÁ¬½ÓµÄÊý¾Ý¿âµÈ²ÎÊý£©»òÒ»¸ö¼ÓÃܵĽ¨±íÎļþ
¼ÓÃܾͿÉÒÔ½â¾öÁË
4Â¥¡¢5Â¥ÄÜ·ñÔÙ˵ÏêÏ¸Ð©ÄØ£¬ÄãÃǵķ½·¨Ã»Óùý
Ïà¹ØÎÊ´ð£º
ÈçÌ⣬²éѯÓï¾ä²ÎÊýÓ¦¸ÃÔõôд°¡£¿
¸ø²ÎÊý¸³Öµ¡¡ÔõôŪ°¡£¿
with Query do begin
tempParam=parameters.addparameter;
tempParam.name='@begindate';
tempParam.Da ......
_RecordsetPtr pRs("ADODB.Recordset");
"provider=SQLOLEDB;Data Source=»úÆ÷Ãû\\SQLEXPRESS;Persist Security Info=False;User ID=sa;PWD=sa;initial catalog ......
ÆäÖÐÒ»¸öoracleÊý¾Ý¿âÖÐÆäÖÐÒ»¸ö±íÓжà¸öʱ¼ä´Á×Ö¶Î,mssqlÖ»ÄÜÔÊÐíÒ»¸öµÄ.
ʵÔÚÓÐÎÊÌâµÄ»°£¬ ¿ÉÒÔÏȽ¨Á¢ÁíÍâµÄÒ»ÕÅ±í£¬È»ºó°Ñtimestamp¸ÄΪdate£¬°ÑÊý¾Ý¸´ÖÆÒÔºó£¬ÔÚÒÆÖ²Ò»´Î
oracleµÄʱ¼ä´ÁºÏ²¢ÎªÒ»¸ö×ֶα ......