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

ÓйØ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


Ïà¹ØÎÊ´ð£º

ACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000

  ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......

sqlserver Êý¾ÝºÏ²¢ÎÊÌâ

ÏÈÓÉÈçÏÂsqlÓï¾ä
select  A,B,C from table1
union
select  A,B,C from table2
order by A, C asc
µÃµ½½á¹ûÈçÏ£º
  A        B      &nbs ......

SwingÀïÃæµÄʼþÓëSQLserverÊý¾Ý¿âµÄÁ¬½ÓµÄÎÊÌâ

СµÜÏÖÔÚSwingÔÚÁ¬½ÓÊý¾Ý¿âÉÏÓöµ½Ò»µãÎÊÌ⣬ÇëÎÊSwingÀïÃæµÄʼþºÍSQLserverÊý¾Ý¿âµÄÁ¬½ÓÓÐʲôºÃµÄ×ÊÁÏÊéÍÆ¼öÂð£¿
Õâ¸öÓ¦µ±Ã»ÓÐÊ²Ã´ÌØ±ð,ÓëÆäËûµÄ±à³ÌÒ»Ñù.

JDBC

ÇëÎÊÔÚSwingÖмÓÔØ±³¾°Í¼Æ¬ÊÇÔõô¼ÓµÄ£¿
......

aspʹÓÃsqlserverÎÊÌâ

ÎÒÔÚsqlserver2000µÄ²éѯ·ÖÎöÆ÷Àï´´½¨ÁËÒ»¸öÊý¾Ý¿â£¬½¨Á˼¸ÕÅ±í£¬²åÈëÁ˼¸ÌõÊý¾Ý£¬±£´æºóÊÇ.sqlºó׺µÄ£¬aspµ÷ÓÃÊý¾Ý¿âÖеÄÊý¾ÝÖ»ÄÜʹÓÃ.mdfµÄ°É£¬ÎÒ¸ÃÔõô×öÄØ£¿½²ÏêϸµãßÀ¡£¡£¡£¡£ÎÒ³õѧ£¬²»Ì«»á....ÏÈллÁË...
Ä ......

sqlserverÖÐorder by ÎÊÌ⣿

ÎÒÏëÔÚorder by ºó¼Ó¶à¸öÌõ¼þ£¬
ÔÚAccessÖÐorder by ¿ÉÒÔÕâÑùʹÓÃ
sql="select  * from pro order by istop=1,pro_date desc"
ÔÚsqlserverÖУ¬ÎÒ¸ÃÈçºÎʹÓÃÄØ£¿
SQL code:

select * f ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ