SQL Server access multi-database operations

Today, it's been a day.

Update the ACCESS library to check the information from the SQL SERVER 2008 repository. I can't find the information but I can do it by myself.

First find out how to use the SQL sentence

SELECT * from Restore_base in [Odbc][odbc;driver=sql Server; Server computer name; uid= account; pwd= password; database=)

Find this.

And then you start to write the update phrase.

I am depressed boring, how to write all write not right. Finally, you can only teach the Niang.

A different approach to access and SQL SERVER 2008

UPDATE TAB1 a,tab2 b

SET A.name = B.name

WHERE a.id = b.id;

And then I wrote it out.

Update Spring, (SELECT * from Restore_base in [Odbc][odbc;driver=sql Server; Server computer name; uid= account; pwd= password; database=) as B

Set Spring.nam = B.descript1

where SPRING.DWG=B.PRODNR

SQL Server access multi-database operations