I want to update DatabaseA.TableA.Col1 with reference to Database2.TableB.Col2
with condition TableA.ColA = TableB.colB
| Code Snippet |
Update A set A.Col1 = B.Col2 from DatabaseA.dbo.TableA inner join Database2.dbo.TableB on A.ColA = B.ColB |
Venkatesan Prabu MCITP,MCAD,MCTS,CCNA. Worked as a ProjectLead(Senior .Net developer,SQL DBA). Now, Managing Director of KAASHIV INFO TECH, Chennai This Blog aims in serving the community in a better way. This blog is read by developers in 159 countries with average of 400 hits per day. Please post your valuable suggestions and hold my hand to serve the community. Lets make a new world with good thoughts and good minds....... This blog serves the SQL server community all over the world.
8.3.08
Updating table in different database in sql server
Problem Statement:
I want to update DatabaseA.TableA.Col1 with reference to Database2.TableB.Col2
with condition TableA.ColA = TableB.colB
I want to update DatabaseA.TableA.Col1 with reference to Database2.TableB.Col2
with condition TableA.ColA = TableB.colB
How can we update the table from another database in another server automatically ?
ReplyDelete