Update table in diff db

[rewdee]

I have to write an update trigger that updates records in another table in another database (same SQL Server though). Do I create another connection (if so, how? Or do I write something like :

USE PUBS
Update Customer blah blah

Any help would be appreciated.

Thanks,
Rewdee

 

[TonyRobinson]

To update a table on a different database on the same server

use the following

update database_name.user.table
set field = value
where ...

i.e.

update database1.dbo.table1
set field1 = "TEST"
where field2 = "TEST"

Same applies for select statements etc.

Hope this helps

 

[dbomrrsm]

UPDATE DBNAME.TABLENAME
SET FIELD1 = (SELECT FIELD1 FROM DB2NAME.TABLENAME
WHERE DBNAME.TABLENAME.IDFIELD = DB2NAME.TABLENAME.IDFIELD)

[blue]DBomrrsm[/blue]