access ÖÐÖ´ÐÐsqlÓï¾äupdate²»³É¹¦£¬ÇóÖú£¡£¡£¡
access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ
sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£
ÊÇACCESS»¹ÊÇSQLSERVER£¿
¼ì²éÒ»ÏÂûÓб»¸üеÄ×Ö¶Î
ÊÇÔÚaccessÀïÃæ Á¬½Ósqlserver È»ºóÖ´ÐÐsql update Óï¾ä£¬ÓÐʱºòÄܳɹ¦£¬ÓÐʱºò²»³É¹¦£¬Äܳɹ¦ËµÃ÷²»ÊÇÓï¾äºÍ¸üÐÂ×ֶεÄÎÊÌ⣬µ«ÊÇÓÐʱºò²»³É¹¦ÎÒ¾ÍÃÔºýÁË¡£¡£¡£¡£ÓôÃÆÖС£¡£¡£¡£
´Ó³ÌÐòÖÐÖ´ÐгöÀ´µÄsql Äõ½²éѯ·ÖÎöÆ÷ÀïÖ´ÐÐÍêȫûÓÐÎÊÌ⣬µ«¾ÍÊdzÌÐòÖ´ÐÐÍêÁË£¬Ã»ÓиüС£¡£¡£
ÓÃVBA¸üУ¿ÔÚʲôÇé¿öϳɹ¦¡¢²»³É¹¦£¿ÄãÒª×ܽáһϣ¬¾ÍĿǰÄãÌṩµÄ×ÊÁÏ£¬ÎÞ·¨ÅжÏ
ÍêÈ«ÏàͬµÄÇé¿öÏ£¬ÓÐʱºòÖ´Ðоͳɹ¦£¬ÓÐʱºò¾Í²»³É¹¦
ÄãµÄÓï¾äÊÇʲô£¿
²»³É¹¦£¬ÄãÊÇÈçºÎÀ´È·¶¨µÄ£¿ ½¨ÒéÀûÓÃdebugÀ´´ò³öÄãÖ´ÐеÄSQLÓï¾ä¡£ »¹ÓоÍÊÇÓÐûÓÐÆôÓÃÊÂÎñ£¿
ÎÒÀ´¶¥
ÔÚaccessÀïÃæÁ¬½Ósqlserver£¿£¿£¿£¿£¿
Ìù³öÓï¾ä°É£¬·ñÔòºÜÄÑ·ÖÎöµÄ
Óï¾äÄØ?
ÄãÖ´ÐÐÁËÏÂÃæÕâ¾ä»°ÁËÂð£¿
String conURL="jdbc:odbc:***";
Connection con=DriverManager.getConnection(conURL);
con.close();//¹Ø±ÕÓëÊý¾Ý¿âµÄÁ¬½Ó
Ïà¹ØÎÊ´ð£º
СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
@p001 nvarchar(8000),
@p002 nvarchar(8000),
@p003 nvarchar(8000),
& ......
ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8
ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£
½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë
ÇëÎÊÎÊÌâÔÚÄÄ£¿
×°¸öÖÐÎÄÈí¼þ¼´¿É.
ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ ......
´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......
C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿
try
{
connection.connect()
return true;
}
catch()
{
return false;
}
Â¥Ö÷ºÜ׿±£¬¿ªÁ˼¸ÌùÁË¡£
ÒýÓÃ
try
{
connection.connect( ......