ÓйØSQLserverÊý¾Ý¿âÁ´½ÓµÄÎÊÌâ
ÔÚSQLserverÊý¾Ý¿âÁ´½ÓÖУ¬ÈçºÎͨ¹ý±¾µØÊý¾Ý¿âºÍÁ´½ÓÊý¾Ý¿â½øÐÐÊý¾Ý±È¶Ôupdate²Ù×÷£¿
ÎÒ¿´µ½Óï·¨ÊÇÕâÑùµÄ
update openquery(cs,'select * from B where id=1111')set id=23
ÎÒÏÖÔÚÐèÒªµÄÊDZ¾µØÓÐÊý¾Ý±íA£¬ÓÐÁ´½ÓÊý¾Ý¿âcs£¬Á´½ÓÊý¾Ý±íB£¬Èç¹ûA.id=B.id,ÄÇôupdate B±í£¬½«A±ípwd×ֶθüе½B±ípwd×Ö¶ÎÖС£¡£Õâ¸öÈçºÎʵÏÖ°¡£¿
Çë¸ßÊÖÃǰïæ½â¾öÏ¡£¡£Íò·Ö¸Ðл~
SQL code:
update openquery(cs,'select * from B where id=1111') B set B.pwd=A.pwd from A WHERE A.ID=B.ID
?
ºÇºÇ¡£É¢·Ö
jf
Ïà¹ØÎÊ´ð£º
ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......
ÏÈÓÉÈçÏÂsqlÓï¾ä
select A,B,C from table1
union
select A,B,C from table2
order by A, C asc
µÃµ½½á¹ûÈçÏ£º
A B &nbs ......
СµÜÏÖÔÚSwingÔÚÁ¬½ÓÊý¾Ý¿âÉÏÓöµ½Ò»µãÎÊÌ⣬ÇëÎÊSwingÀïÃæµÄʼþºÍSQLserverÊý¾Ý¿âµÄÁ¬½ÓÓÐʲôºÃµÄ×ÊÁÏÊéÍÆ¼öÂð£¿
Õâ¸öÓ¦µ±Ã»ÓÐÊ²Ã´ÌØ±ð,ÓëÆäËûµÄ±à³ÌÒ»Ñù.
JDBC
ÇëÎÊÔÚSwingÖмÓÔØ±³¾°Í¼Æ¬ÊÇÔõô¼ÓµÄ£¿
......
ÎÒÔÚsqlserver2000µÄ²éѯ·ÖÎöÆ÷Àï´´½¨ÁËÒ»¸öÊý¾Ý¿â£¬½¨Á˼¸ÕÅ±í£¬²åÈëÁ˼¸ÌõÊý¾Ý£¬±£´æºóÊÇ.sqlºó׺µÄ£¬aspµ÷ÓÃÊý¾Ý¿âÖеÄÊý¾ÝÖ»ÄÜʹÓÃ.mdfµÄ°É£¬ÎÒ¸ÃÔõô×öÄØ£¿½²ÏêϸµãßÀ¡£¡£¡£¡£ÎÒ³õѧ£¬²»Ì«»á....ÏÈллÁË...
Ä ......
ÎÒÏëÔÚorder by ºó¼Ó¶à¸öÌõ¼þ£¬
ÔÚAccessÖÐorder by ¿ÉÒÔÕâÑùʹÓÃ
sql="select * from pro order by istop=1,pro_date desc"
ÔÚsqlserverÖУ¬ÎÒ¸ÃÈçºÎʹÓÃÄØ£¿
SQL code:
select * f ......