Changing data in different tables

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Changing data in different tables

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-07 : 09:07:35

Marcel writes "I like to know how I kan change or update the data in a column in different tables in one database. I'm using Microsoft SQL 2000. The data is an administration number which is the same in alle tables. The database is a financial administration, in this database the administration number is stored in different tables. This makes it impossible to make any copies of the administration because the administration number must be an unique value.

With kind regards,

Marcel Leimena"

Nazim
A custom title

1408 Posts

Posted - 2002-03-07 : 09:14:16

you can do it by using four part naming convention

Server.database.owner.tablename

Eg: for your query

update t1 set t1.fieldname=t2.fieldname from databasename.tablename t1 inner join databasename.tablename
on t1.commonekey=t2.commonkey

HTH

--------------------------------------------------------------

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources