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
 Transact-SQL (2000)
 Joining data from two databases on same server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-01-31 : 08:20:07
Steve writes "I have a database which holds tables of which one is a code, the description to this is held in another database on same server.
How do I extract the description to populate the code with description i.e. 0111 = test
Thanks"

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-01-31 : 08:43:55
use 4 part naming convention:
serverName.DbName.OwnerName.TableName

Go with the flow & have fun! Else fight the flow
Go to Top of Page
   

- Advertisement -