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 2008 Forums
 Other SQL Server 2008 Topics
 reference another database in the same sql server

Author  Topic 

rchiu5hk
Starting Member

7 Posts

Posted - 2008-12-21 : 21:42:37
How to reference tables in another database in the same host of sql server, from the stored procedures?

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-12-21 : 22:09:56
quote:
Originally posted by rchiu5hk

How to reference tables in another database in the same host of sql server, from the stored procedures?



Like this

Databasename.schema.tablename
Go to Top of Page
   

- Advertisement -