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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-08-25 : 19:04:02
|
| Elias writes "hi my problem is that i have a database in wich i'm making my stored procs but i'd like to get data from a table that exists on another database inside my server, is that possible and how?i'm using SQL SERVER 2000 With WINDOWS XP SP1 and i'm pratically a newbie to stored procedures so please be gentle and patiente with methanks" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2004-08-25 : 19:10:08
|
| Access the data using 3 part naming conventionDatabase.Owner.NameSelect * from Pubs.dbo.Authors orSelect * from Pubs..Authors -Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
|
|
|
Can i get data from one database to another?